What is a cold backup?

What is a cold backup?

Cold backup, also known as offline backup, refers to a complete backup of the database when the database is closed and the database cannot be updated, and the data can be restored in a specified manner. Its advantages are simple operation. And the cold backup database can work in non-archive mode.

Advantages of cold backup

1. It is a very fast backup method (just copy files)

2. Easy to archive (just copy)

3. Easy to restore to a certain point in time (just copy the file back)

4. Can be combined with archiving methods, Do database "best state" recovery.

5. Low maintenance, high security.

Disadvantages of cold backup

1. When used alone, it can only provide recovery to "a certain point in time".

2. During the entire process of implementing backup, the database must be backed up and no other work can be performed. In other words, during the cold backup process, the database must be closed.

3. If the disk space is limited, you can only copy to tapes and other external storage devices, which will be very slow.

4. It cannot be restored by table or user.

If possible (mainly depends on efficiency), the information should be backed up to disk, then start the database (so that users can work) and copy the backed up information to tape (while copying, the database can also work ).

Recommended tutorials: "PHP" "MySQL Tutorial"

The above is the detailed content of What is a cold backup?. For more information, please follow other related articles on the PHP Chinese website!