Posts tagged backup

MySQL> Easy export/import

Oct29
2010 Written by Scott Rowley

The following is a quick and easy way to export and import a mysql database.
Keep in mind if at the new location the database doesn’t exist you will need to create it first.

Export:

mysqldump -u USER -p DATABASE > backup.sql

Import:

mysql -u USER -p DATABASE < backup.sql
Posted in MySQL - Tagged export, import, MySQL, mysqldump

Corrections? Questions? Comments?

Find an error?
Everything work out great for you?
Have some feedback?
Like to see something added to the article?

PLEASE leave us a comment after the article and let us know how we are doing, or if something needs corrected, improved or clarified.

Thank you!
- The Management

Advertisement

Back to Top