MySQL Backup and Restore: Difference between revisions
Jump to navigation
Jump to search
(Created page with "== Backups == === Backup all databases === <tt>'''# mysqldump -p -uroot --all-databases > [sql_server_name].sql'''</tt> === Backup a specific database === <tt>'''# mysqldump ...") |
No edit summary |
||
| Line 11: | Line 11: | ||
== Further Reading == | == Further Reading == | ||
[http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database Backing up and Restoring Your MySQL Database] | # [http://www.devshed.com/c/a/MySQL/Backing-up-and-restoring-your-MySQL-Database Backing up and Restoring Your MySQL Database] | ||
Revision as of 17:57, 3 January 2012
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