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

Add a comment