MySQL Data migration

On the source host, first use the mysqldump command to back up and export the SQL script file

- - > /opt/tel_dev.sql

You can also specify the encoding

- - -- Default-character-set=utf8 Tel >/opt/tel_dev.sql

Backup method when connecting remotely

- 192.168. 0.130 - - > /root/tel_dev.sql

Copy Tel_dev.sql from the source host to the target host

SCP root@192. 168.0. :/root/root/

Then on the target host, create the database

MySQL>Createdatabase Tel_dev;

Restore data with an exported backup file

- - < D:\tel_dev.sql

Specify encoding Restore

- - -- default-character-set=utf8-f Tel_dev < D:\tel_dev.sql

MySQL Data migration