MySqlDump export and MySQL import

To export data as a backup you can’t beat mysqldump.

# mysqldump -u username database > database_2007-05-14.sql

Then to restore a database you would use:

# mysql -u username -p database < database_2007-05-14.sql

It doesn’t get any easier than that!

Published by


Speaker, author, consultant, OSS contributor, SoFloPHP UG and SunshinePHP Conf organizer, RunGeekRadio Host, Long distance runner and ultra marathoner.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.