MySQL database data migration from one server to another requires that the database be exported and then imported from another server. There are many ways to do this, and the MySQL companion tool has this feature. phpMyAdmin can do it, but this is slow to load, it is recommended to use the import and export function of MySQL Workbench.
The first step: Export the database of the local server:
Click to start the export after the appearance of such a picture indicates success.
Step two: Upload the generated. sql file to the server
Step three: Open MySQL Workbench on the server and import the above file:
Click to start the import, the display shows that the import success:
Then look in the left database column, refresh the database, you will see the imported database
At this point: the database migration is complete. ^_^
MySQL Database migration graphic display