How to Use the MySQL commercial backup tool to buy a commercial version of the user, you can use commercial backup tools to back up the MYSQL database, I will demonstrate how to back up and restore. This includes full backup and Incremental backup. Full backup method: [SQL] mysqlbackup -- defaults-file = "H: \ Program Files \ MySQL \ mysql-advanced-5.6.10-winx64 \ my. ini "-- port = 3313 -- protocol = tcp -- user = root -- password -- backup-dir =" j: \ mysqlbackup "backup-and-apply-log ------------------------------------------------------------- Parameters Summary restart Start LSN: 18122752 End LSN: 18126599 -------------- ------------------------------------------- Incremental: [SQL] mysqlbackup -- defaults-file = "H: \ Program Files \ MySQL \ mysql-advanced-5.6.10-winx64 \ my. ini "-- port = 3313 -- protocol = tcp -- user = root -- password -- incremental -- start-lsn = 18126599 -- incremental-backup-dir =" j: \ mysqlbackup_inc "backup --------------------------------------------------------------- Parameters Summary ---------------------------------- ------------------------- Start LSN: 18126600 End LSN: 18134788 ------------------------------------------------------------- merge the incremental data to the full data, forming a new full data. [SQL] mysqlbackup -- backup-dir = "j: \ mysqlbackup" -- incremental-backup-dir = "j: \ mysqlbackup_inc "apply-incremental-backup Restore method stop MYSQLD [SQL] mysqlbackup -- defaults-file =" H: \ Program Files \ MySQL \ mysql-advanced-5.6.10-winx64 \ my. ini "-- datadir =" H:/Program Files/MySQL/mysql-advanced-5.6.10-winx64/data "-- backup-dir =" j: \ mysqlbackup "copy-back if the following information appears, indicates that the recovery is successful. Otherwise, the Recovery fails. Mysqlbackup completed OK!