MySQL Backup Topics

MySQL Backup Topics

Privileges for MySQL backup and restore job

*/ /*-->*/

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.

How to migrate mysql backup to new computer?

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)

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

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 v6.0.4

mysql backup screenshot

View Screenshot
( 2020.04.04 )

            MySQL Backup is a very easy to use backup and restore application for MySQL . It creates 7z , zip ,gz ,raw sql backup for local or remote MySQL Server's databases easily and quickly . The user-friendly and professional wizard enables you just point and click with your mouse to do backup / restore job , without writing any sql script or complicated command line . It supports data compression and encryption . It is really a must-have tool for MySQL DBA.

    Screenshot           Download

MySQL Backup main window

MySQL Backup main window

Click to enlarge.

MySQL Backup window

MySQL Backup window

Click to enlarge.

Send email after job

Email after job

Click to enlarge.

More ... ...