Updated 12 years ago
One database to another in one CLI call.
mysqldump -u USER -pPASS DB_NAME | mysql -u USER -pPASS NEW_DB_NAME