Posts in category MySQL

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
Tagged backup, export, import, mysqldump
Newer Entries »

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