A pretty neat command that copies one database into another database from the command line in one simple command: $ mysqldump -u USER -pPASS FROM_DATABASE | mysql -u USER -pPASS TO_DATABASE Nice and easy! 🙂