Clone MySQL database

mysql database mysqldump

$ mysqldump yourFirstDatabase -u user -ppassword > yourDatabase.sql$ mysql yourSecondDatabase -u user -ppassword < yourDatabase.sql

mysql database mysqldump

mysqldump -u <user> --password=<password> <DATABASE_NAME> | mysql -u <user> --password=<password> -h <hostname> <DATABASE_NAME_NEW>

mysql database mysqldump

Like accepted answer but without .sql files:

mysqldump sourcedb -u <USERNAME> -p<PASS> | mysql destdb -u <USERNAME> -p<PASS>

CodeHunter