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

Adam

Application Architect from Florida

Leave a Reply

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