How to Export/Import Text Labels via Database

 Link: https://support.brilliantdirectories.com/support/solutions/articles/12000089230

In this article, we will be going over how to import and export the text labels from one site to another using the database. This can be a good workaround for site owners with multiple sites in a different language where all translated text labels can be transferred from one site to another.

1) How to Export Text Labels

To accomplish this, navigate to Developer Hub >> MySQL Database:

Click on _directory database:

Search for the table website_labels and click on it:

Click on the Export navigation link:

Choose the Custom option:

Name the file and choose the gzipped Compression option:

Select Add Drop Table / Trigger statement option:

And click on Go and the file will be downloaded:

2) How To Import Text Labels

Now that your export file is ready and downloaded, we can navigate to a different site to which we want to import these text labels.

To accomplish this, navigate to Developer Hub >> MySQL Database:

Click on _directory database:

Click on the Import navigation link:

Choose the correct exported file and click on Go:

There will be an indication on the queries were executed correctly: