MySQL Backup type

Backup is a necessary means of just in case, in the event of hardware corruption or non-human factors resulting in data loss, you can use a backup to recover data to minimize the loss, so the backup must be, and the backup is divided into the following types:

1, according to whether the server online:

Cold backup, i.e. server not in line, offline backup, cold backup

Hot backup, i.e. online server backup

Warm backup: Warm backup, can read, cannot write

2. According to the data set backed up:

Full backup:

Partial backups: Partial backup

3, according to the interface of the backup: directly back up the data file or through MySQL export data

Physical backup: Direct copy of the archive data file backup method

Pros: Fast Backup

Disadvantage: If the backed up data source is corrupted, the backed up data is unrecoverable

Logical way: The data is extracted from the database and saved as a text file

Pros: Data that can be backed up can be restored

Disadvantage: Large backup space, slow recovery, can not guarantee the accuracy of floating point numbers, and to rebuild the index, station CPU resources

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

Full backup

Manual or performing tasks perform a full backup of the data from the last or first time, and if the data is large, it takes up a lot of time and space, but when data loss occurs, a full backup is used

Incremental backup

Requires a professional backup tool that involves data time recognition after a full backup, each backup will only back up the data generated from the last backup to the backup time, so the data for each backup is smaller than the differential backup, but the recovery data is not very convenient and recovery is slow, but the backup is faster

Differential backup

Data that has been generated since the last full backup, that is, every time the data that was generated from the previous full backup is backed up once, so the size of the backup will grow as the date grows until a full backup is made, but the differential backup is the most convenient and quick to restore the data with a full backup.

650) this.width=650; "src=" http://s3.51cto.com/wyfs02/M02/53/B0/wKioL1RtuISAmG_FAAFGxfTFTgQ771.jpg "title=" 1.jpg " alt= "Wkiol1rtuisamg_faafgxftftgq771.jpg"/>

This article is from the "Linux" blog, so be sure to keep this source http://zhangshijie.blog.51cto.com/806066/1580227

MySQL Backup type