How to use the latest MySQL commercial Backup Tool

Users who bought the commercial version can use commercial backup tools to back up the MYSQL database. I will demonstrate how to back up and restore the database. This includes full backup and Incremental backup.

Backup Method

Full:

1. 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
2. -------------------------------------------------------------
3. Parameters Summary
4. -------------------------------------------------------------
5. Start LSN: 18122752
6. Endlsn: 18126599
7. -------------------------------------------------------------

Increment:

1. 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
2. -------------------------------------------------------------
3. Parameters Summary
4. -------------------------------------------------------------
5. Start LSN: 18126600
6. Endlsn: 18134788
7. -------------------------------------------------------------

The incremental data is merged to the full data to form a completely new full data.

Mysqlbackup -- backup-dir = "j: \ mysqlbackup" -- incremental-backup-dir = "j: \ mysqlbackup_inc" apply-incremental-backup

Recovery Method.

1. Stop MYSQLD
2. 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 is displayed, the recovery is successful. Otherwise, the operation fails.

Mysqlbackup completed OK!