Use mysql management software to import, restore/export, and back up mysql.

Using mysql management tools to import and export can avoid garbled text issues during data import and export. There are many mysql management tools. This article mainly introduces how to use Navicat Premium. The software can be searched and downloaded from the official website. This article comes from the Internet.

Note: Using software management requires enabling mysql remote connection (using root is not recommended). Our virtual hosting supports remote connection by default.

If your server has not enabled it, you can refer to:Enabling mysql root remote access on vps, cloud host, and dedicated server 

To enable remote access in 宝塔面板, you can refer to: https://www.west.cn/faq/list.asp?unid=2447 

Data backup and migration process:First connect to the old database server to perform export, then connect to the new server to import.

Open the software, Connection -- mysql

Fill in the mysql database information, and after confirmation you can connect.

Export:

Right-click the database to be exported, Dump SQL File -- Structure and Data, then select the local save path and confirm to execute.

Import:

Right-click the database to be imported -- Run SQL File, then select the sql file to import and execute.

If you see this prompt, it means it was successful.