Duplicate Entire MySQL Database

Question

Is it posible to duplicate an entire MySQL database on a linux server?

I know I can use export and import but the original database is >25MB so that's not ideal.

Is it possible using mysqldump or by directly duplicates the database files?

Answer 1

First create the duplicate database:

CREATE DATABASE duplicateddb; 

Make sure the user and permissions are all in place and:

 mysqldump -u admin -p originaldb | mysql -u backup -pPassword duplicateddb;  

Answer 2

To remote server

mysqldump mydbname | ssh host2 "mysql mydbcopy" 

To local server

mysqldump mydbname | mysql mydbcopy