What is mysql physical backup?

Explanation

1. Physical backup is divided into two types: cold backup and hot backup.

2. Compared with logical backup, its advantage is that backup and recovery are faster, because the principle of physical backup is based on file cp.

Example

There are many methods for hot backup of myisam storage engine. The essence is to add a read lock to the table to be backed up, and then cp the data file to the backup directory.

Use the mysqlhotcopy tool

// mysqlhotcopy 是 MySQL 的一个自带的热备份工具  
shell> mysqlhotcopy db_name [/path/to/new_directory]

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