Home >Topic List >mysql backup data method

mysql backup data method

MySQL backup data methods include physical backup and logical backup. Detailed introduction: 1. Physical backup. Physical backup is to directly copy the binary file of the database to another location. This backup method is very fast and efficient, but it requires stopping the operation of the database; 2. Logical backup. Logical backup exports the data in the database into a readable text file. This backup method is slower than physical backup, but it can be backed up while the database is running.