How to quickly import/export MySQL database scripts

12 May, 2008  Linux, Mac OS X, MySQL

# 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!

Leave a Comment

You must be logged in to post a comment.