How can I easily copy a database?
Available options include:
Use replication. Run
REPLICATE DATABASE dest_db FROM user@host:port/src_db
, and after it fully synchronizes runSTOP REPLICATING dest_db
. See Replicating Data Across Clusters .BACKUP the database and RESTORE it on the same (or a different) cluster under a different name.