How to quickly import/export MySQL database scripts
# Export MySQL Database Script
mysqldump -uroot -p db_name_1 > dump_name.sql
# Import MySQL Database Script
mysql -uroot -p db_name_2 < dump_name.sql
Importing a MySQL database script (.sql) will potentially overwrite data! (That’s what it’s supposed to do.) Make sure you know that what you’re doing is safe!-)
Done!