MySQL backup and recovery operations (MYSQL statement operation tutorial 3)

Database backup

To complete the data backup in command line mode, use the MYSQLDUMP command. This command can be used to store data in the form of text files in the specified folder.

Note: To operate the mysql database in command line mode, you must set the computer's environment variables. Right-click "My Computer", select the "Properties" command in the pop-up shortcut menu, select the "Advanced" tab in the pop-up "Properties" dialog box, and then click the "Environment Variables" button in the new pop-up dialog box. Find the variable PATH in the list box of user variables and select it, click the "Edit" button, add the installation path of the bin folder in the mysql database in the variable value text box of the variable PATH, and then add the "OK" button. The path to the bin folder depends on the location where you installed the mysql database.

Note: If you use the integrated installation package to configure the PHP development environment, you do not need to perform the above settings because of the integration. The installation package has been configured by itself. However, if mysql is installed independently, the above settings must be made to operate the mysql database in command line mode.

Steps to back up the entire database through the MYSQLDUMP command. As follows:

(1) Select the "Start"/"Run" command.

(2) Enter cmd and click OK to enter the command line mode (3). Directly enter "mysqldump -uroot -proot db-darabase 16>F:\db_database16.txt" in the command line mode, and then press the Enter key.

The "root" in -uroot is. The user name, and "root" in -proot is the password, "db_database16" is the database name, and "F:\db_database16.txt" is the location where the database backup is stored. Finally, you can check whether there is a backup in this folder. Database file.

Note: When entering the command, there is no space in "-uroot", and there is no terminator at the end of the command. Just click the Enter key.

Data recovery

Since the database can be backed up, the database file must be backed up Perform the recovery operation. The MySQL command is used to perform the database recovery operation. The command format is as follows:

mysql -uroot -proot db_database

where mysql is used. command, the root after -u represents the user name, the root after -p represents the password, db_database represents the database name (or table name), and F:\db_database16.txt after the "<" sign is the location where the database backup file is stored.

The following are the steps to implement database recovery:

(1) Select the "Start"/"Run" command (2) Enter cmd and click OK. , enter command line mode.

(3) Directly enter "mysql -uroot -proot db-darabase16>F:\db_database16.txt" in the command line mode, and then press the Enter key.

Among them, "root" in -uroot is the user name, and "root" in -proot is the password, "db_database16" is the name of the database to be restored, and "F:\db_database16.txt" is the database The location where the backup files are stored. Finally, you can check whether there is a backup database file in this folder.

Note: When performing database recovery, there must be an empty database to be restored in the MySQL database, otherwise an error will occur.

The above is the detailed content of MySQL backup and recovery operations (MYSQL statement operation tutorial 3). For more information, please follow other related articles on the PHP Chinese website!