MySQL Advanced five--backup and recovery

First, the purpose of backup:

For recovery, the data to be backed up is tested for recovery.

A backup is for a database.

Second, the type of backup:

1, depending on whether the server is online during backup:

(1), Cold Cold backup: Offline backup.

(2), Win Bei warm backup: Readable only, not writable.

(3) Hot standby: Online backup.

2. According to the data set backed up:

(1) Full backup

(2). Partial backup: Partial backup, only some tables are backed up

3. Depending on the interface at the time of backup (directly backing up data files or exporting data via MySQL server):

(1), Physical backups physical backup:

Copy the data file directly.

(2), logical backup logical:

Extract the data from the library and save it as a text file (the accuracy of the floating-point numbers cannot be guaranteed and the index will be lost).

Mysqldump

4. Backup the entire data or only the changed data based on backup

(1) Full backup

(2), incremental backups: Incremental backup

(3), differential backups: differential backup

MySQL Advanced five--backup and recovery