MySQL Backup and Restore

From UNIX Systems Administration
Revision as of 16:27, 5 January 2012 by Michael Kohler (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

Backups

Backup all databases

# mysqldump -p -uroot --all-databases > [sql_server_name].sql

Backup a specific database

# mysqldump -p -uroot [database name] > [database name].sql

Restore

Restore from a MySQL Dump

# mysql -p -uroot [database name] < [database name].sql

Further Reading

  1. Backing up and Restoring Your MySQL Database
Retrieved from "http://www.outlandsmud.com/wiki/index.php?title=MySQL_Backup_and_Restore&oldid=241"