MySQL copy command for different database with host

First build the target library and assign permissions.

Mysqladmin Create Nemopro

From Nemob2b to Nemopro

Replication commands for different databases with host :

1. Small amount of data (within 1M)

Mysqldump nemob2b-u Root-ppassword--add-drop-table | MySQL nemopro-h mysqlhost-u Root-ppassword

2. Large data volume (can exceed 1G)

5.6\bin>mysqldump-unemo-pnemo--default-character-set=utf8--quick nemob2b | gzip >interface5.6\bin>gunzip < nemob2b.gz | Mysql-unemo-pnemo  Nemopro--default-character-Set=interface can be Insecure.

If you are copying to a remote other MySQL server , you can use the "-H hostname/IP" parameter of MySQL. The premise is that MySQL allows remote connections, and the transfer efficiency and time of remote replication are acceptable.

Mysqldump Nemob2b-uroot-ppassword--add-drop-table | Mysql-h 192.168.1.22 Nemopro-uroot-ppassword

MySQL copy command for different database with host