MySQL database backup and Restoration

When a database is used, database backup is performed. When a database fails to be started due to a serious error or data loss, data can be restored in a timely and effective manner. This article briefly introduces how to back up and restore a MySQL database.

Back up database

Back up a database using the mysqldump command

# If you want to back up the game database: mysqldump-u root-p game> game_backup. SQL # if you want to back up all the databases: mysqldump-u root-p -- all-databases> all_backup. SQL

Restore database

1. Use the mysql command to restore the database

Restore game_backup. SQL to the game Database:

Mysql-u root-p game <game_backup. SQL

2. Use the source command to restore the database

If the database is too large, we recommend that you use the source command.

Mysql> source game_backup. SQL