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# 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# mysql -u username -p database < database_2007-05-14.sql It doesn’t get any easier than that!