MySQL Backup Topics

Since v4.5.8 , mysql backup checks privileges before job. Following table shows privileges checked in backup and restore job (no privilege checked in a synchronization job) . Please note that, if mysql backup reports privilege warnning message, it dosen't mean you can not run the job. For example, if mysql backup reports no "Show view" privilege for a backup job, if your database has no view object, it is ok for the job.

There are two way to migrate mysql backup software to new computer :

A ) Migrate by copying file

1 . Copy all backups to new computer to same directory as old one.

2 . Copy all program files in installation direcotry to new computer (same directory requires).

3 . In old program , click File->Open configuration direcotry menu , and copy all files to new program configration direcry.

4 . Re-enter the license key if it asks.

B) New install and import old backup (recommended)

Following links are complete list of FAQs online , you will get mostly answers to specific questions here.
 

Following error occurs in backup file after a failed backup job.

-- Couldn’t execute ‘SELECT @@GTID_MODE’: Unknown system variable ‘GTID_MODE’ (1193) --

You got this message because MySQL Backup backup agent uses a newer version of mysqldump on your older version MySQL database , and your database server dose not support "GTIDs" . 

GTIDs means Global Transaction Identifiers (GTIDs) , GTIDs make it simple to track and compare replication across a master-slave topology ,is  introducted in MySQL 5.6 .

MySQL Backup software uses mysqldump.exe as backup interface to get mysql data .

Following is list of mysqldump , if current version of MySQL Backup software  can not back up your database ,  please download a correct version of mysql dump and place all files in

{installation directory}\mysql  

MySQL Backup Update Details ( How to upgrade to the latest version of MySQL Backup)