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.
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.
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:
Increment:
The incremental data is merged to the full data to form a new full data.
Mysqlbackup -- backup-dir = "j: \ mysqlbackup" -- incremental-backup-dir = "j: \ mysqlbackup_inc" apply-incremental-backup
Recovery Method.
Stop MYSQLD
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!