Migrating Data using Mysqldump

1, first stop the business, using mysqldump Data Export tool, your offline database data exported to a data file

Mysqldump-hlocalhost-uroot  --default-character-set=utf8-r  db_name   -p*********** >/tmp.sql

2, view the original database to view the user's authorization information, copy to the new database

Select ' user_name;

for [email protected]'IP';  

3. Execute on the new database

GRANT USAGE on * * to ' user_name ' @ ' IPs ' identified by PASSWORD ' ********************************** ';

4. Execute on the original database

Show CREATE DATABASE;

5. Then copy the build statement

6. Import data

Mysql-uroot-s/var/lib/mysql_3307/mysql_3307.sock--port=3307 -p***************** db_name <./tmp.sql

7. Firewall

3307

Migrating Data using Mysqldump