15th October, 2010

Export/Import mysql data.

To export:

mysqldump --routines -u root -p -h SOURCE_IP SOURCE_DATABASE_NAME > EXPORT_FILENAME.sql

To import:

mysql -u root -p -h DESTINATION_IP DESTINATION_DATABASE < EXPORT_FILENAME.sql

 

The opinions expressed here are my own and not those of my employer.