MySQL remote Export and Import

MySQL remote export and import MySQL remote connection commands can be used to remotely import and export data, which is not limited by the size of 2 MB file in phpMyAdmin. You can also specify the data encoding to ensure that the imported data will not contain garbled characters, the specific command is as follows: mysqldump -- default-character-set = gb2312-192.168.1.1-uroot-pxxxxxx mydatabase> D:/data. SQL

-H is followed by an IP address,-u is followed by a user name,-P is followed by a password, mydatabase is the database name, D:/data. SQL is the exported data file. After execution, the database is backed up to the local device. You can use scheduled tasks to back up the database regularly.

The following command is similar to how to restore data:
MySQL -- default-character-set = gb2312-h192.168.1.1-uroot-pxxxxxx mydatabase <D:/data. SQL
After the execution, the database will be restored, and there will be no garbled characters.