The use of MySQL database backup, there is a very formal database backup method, and other database server has the same concept, but have not thought, MySQL will have a more concise use of file directory backup method, and quickly good.
First, data backup shortcuts
Since this method has not been formally validated by official documentation, we call it a trial.
Purpose: Back up a MySQL database testa in the Hosta host and revert to the HOSTB machine
Test environment:
Operating system: Winnt4.0,mysql3.22.34,phpmyadmin 2.1.0 Chinaz
Install the MySQL database in hosta and build the Testa database
HOSTB machine installed MySQL database, no testa database
Method steps:
Start phpMyAdmin View the list of databases in Hosta and HostB, there is no Testa database in HostB
Locate the MySQL installation directory in Hosta and locate the database directory data
In my test environment, this directory is
C:\MySQL\data
Locate the subdirectory of the corresponding database name
C:\MySQL\data\TestA
Paste Copy to HostB data directory, hosta same as hostb mysql file directory
Refresh HostB phpMyAdmin Look at the list of databases, we see Testa has appeared, and make query changes, and so on, the backup recovery is successful
Test conclusion: MySQL database can be saved by file form, backup, restore as long as the corresponding file directory recovery, no need to use other tools to back up.
http://www.bkjia.com/PHPjc/318553.html www.bkjia.com true http://www.bkjia.com/PHPjc/318553.html techarticle The use of MySQL database backup, there is a very formal database backup method, and other database server has the same concept, but have not thought, MySQL will have more concise use of the document ...
