Mysql database copy command
Create database mysql -uroot -p CREATE DATABASE `newdb` DEFAULT CHARACTER SET UTF8 COLLATE UTF8_GENERAL_CI; Copy database mysqldump db1 -u root -p123456 –add-drop-table | mysql newdb -u root -p123456 If different server mysqldump db1 -uroot -p123456 –add-drop-table | mysql -h 192.168.1.22 newdb -u root -p123456