MySQL backup and restore

Backing up

# back up the database 'database_name' 
# to a file named 'database_backup.sql'
mysqldump -u username -p database_name > database_backup.sql

# back up multiple databases
mysqldump -u username -p --databases database_one database_two > two_databases.sql

# back up all databases
mysqldump --opt --all-databases > all_backup.sql

Restoring a backup

# restore the database 'database_name' 
# from the file 'database_backup.sql'
mysql -u username -p database_name < database_backup.sql

# restore a single database from a 
# dump of multiple databases
mysql -u username -p --one-database database_name < all_backup.sql
Snippets and tagged