mysqldump -h[DB_HOST] -u[DB_USER] -p[DB_PASS] [DB_NAME] | mysql -h[DB_HOST] -u[DB_USER] -p[DB_PASS] [DB_NAME]
Export and import database mysql with a command line

mysqldump -h[DB_HOST] -u[DB_USER] -p[DB_PASS] [DB_NAME] | mysql -h[DB_HOST] -u[DB_USER] -p[DB_PASS] [DB_NAME]