May 14th, 2007
MySqlDump export and MySQL import
To export data as a backup you can’t beat mysqldump.
# mysqldump -u username database > database_2007-05-14.sqlThen to restore a database you would use:
# mysql -u username -p database < database_2007-05-14.sqlIt doesn’t get any easier than that!