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