MySQL Backup and Restore: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
Line 12: | Line 12: | ||
== 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] | ||
[[Category:MySQL]] |
Revision as of 16:24, 5 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