MySQL Database Backup

Mysql tutorial database tutorial backup

When using mysql databases, database backup is the most common and important. So we will first introduce database backup. Database Backup is also a formal database backup method. It shares the same concept with other database servers, but have you ever thought that mysql will have a simpler backup method using the file directory, and it's always better (this method has not been verified in the official documentation. We call it a test now ).

Objective: To back up a mysql database testa in the hosta host and restore it to the hostb host.

Test environment:

Operating System: winnt4.0, mysql3.22.34, php tutorial myadmin 2.1.0;
Install the mysql database in hosta and create a testa database;
The mysql database is installed on the hostb and does not have the testa database.

Procedure:

1. Start phpmyadmin to check the database list in hosta and hostb, and there is no testa database in hostb;

2. Find the mysql installation directory in hosta and the database directory data;

3. In my test environment, the directory is c: mysqldata;

4. Find the subdirectory c: mysqldatatesta of the corresponding database name;

5. paste and copy the file to the data directory of hostb, which is the same as that of the data Directory of hostb mysql;

6. Refresh the phpmyadmin of hostb and check the database list. We can see that testa has appeared, and the query and modification operations are normal. The Backup recovery is successful.

Test conclusion: mysql databases can be stored, backed up, and restored in the form of files. You only need to restore the corresponding file directories without using other tools for backup.