Copying MySQL Databases to Another Machine

#mysqladmin -h other_hostname create db_name

#mysqldump db_name | mysql -h other_hostname db_name

หาก Network ช้า ให้ใช้คำสั่ง

#mysqladmin create db_name

#mysqldump -h other_hostname –compress db_name | mysql db_name

 

Credit : https://dev.mysql.com/doc/refman/5.7/en/copying-databases.html