Q:

Duplicate Entire MySQL Database

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?

A:

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; 

A:

To remote server
mysqldump mydbname | ssh host2 "mysql mydbcopy"

To local server
mysqldump mydbname | mysql mydbcopy

A:

I sometimes do a mysqldump and pipe the output into another mysql command to import it into a different database.
mysqldump --add-drop-table -u wordpress -p wordpress | mysql -u wordpress -p wordpress_backup

