MySQL Cloning the database using mysql-utilities' mysqldbcopy

gistfile1.txt

mysqldbcopy is part of mysql-utilities.

apt-get install mysql-utilities (if not yet installed)

Usage: mysqldbcopy --source=user:pass@host:port:socket --destination=user:pass@host:port:socket orig_db:new_db

Example:
mysqldbcopy --source=user_name:password@localhost:3306 --destination=user_name:password@localhost:3306 mddb:mddb_demo

Working Example:
su root;
mysqldbcopy --source=root@localhost:3306 --destination=root@localhost:3306 yddb:yddb_bk

su root;
mysqldbcopy --source=joomla_user:df*********s@localhost:3306 --destination=joomla_user:df*********s@localhost:3306 mddb:mddb_bk