What does cold backup mean?

What does cold backup mean?

Cold backup is also called offline backup. It refers to a complete backup of the database when the database is closed and the database cannot be updated. It can also perform specified recovery of the data. It usually occurs when the database is normal. In the case of shutdown, a complete database will be provided to us when shut down normally.

Advantages of cold backup

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

2. Easy to archive (just copy )

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

4. Can be combined with the archiving method to restore the "best state" of the database .

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: "MySQL Tutorial" "Oracle Tutorial"

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