MySQL Backup and Restore: Difference between revisions
Jump to navigation
Jump to search
No edit summary |
No edit summary |
||
| Line 13: | Line 13: | ||
# [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: Software]] | |||
[[Category:MySQL]] | [[Category:MySQL]] | ||
Latest revision as of 16:27, 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