27_ database Backup and Recovery

Backup and recovery system in operation, incremental backup, and overall backup example: Sunday overall backup, Monday to Saturday backup Day      If there is a problem in Friday, you can use the overall backup of Sunday + 周一、二, three or four incremental backup to recover. ----------------------------------------------------Backup: Backup tool: There are 3rd party fee backup tools, At present, we learn that the system comes with the backup function Mysqldumpmysqldump can export libraries, tables. Mysqldump does not need to log on to the MySQL command line. Example 1. Export the table under the WWW library     mysqldump -u user name  -p password   Library name   Table 1  table 2  table 3 >   Address/backup file name      exported is a build Table statement and insert statement.      Example 2. How to export all tables under a library     mysqldump -u user name  -p password   Library name   >  address/backup file name Example 3. How to export several libraries on a server in a library     mysqldump -u user name  -p password  -B  Library 1   Library 2  Library 3 >  address/backup file name Example 4. How to export all Library     mysqldump -u username  -p password  -A >  address/backup file name----------------------------------------------------recovery: There are two ways to recover, one is to log on to the MySQL command line , do not need to login to the MySQL command line 1. Log in to MySQL command line   ① for backup file: mysql>source  backup file address    ② for restoring a table-level backup file:msyql>use  library name     mysql>source  backup file address 2. Do not log on to the MySQL command line   ① for the recovery library-level backup file: C:\documents and settings\ Administrator>mysql -u User name  -p password  <  Library-level backup file address   ② for recovering table-level backup files:c:\documents  And settings\administrator>mysql -u User name  -p password   Library name  <  table-level backup file address

27_ database Backup and Recovery