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: