You are here

MySQL Backup Topics

MySQLDumps

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  

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 .

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)

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.

What is MySQL Backup?

MySQL Backup is a very easy to use backup and restore application for MySQL . By using it , you can back up local or remote MySQL Server's databases to your local hard disk or network shared folder 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.

MySQL Backup / Restore Software solutions

1) . Back up remote MySQL Server database, save backup to your local computer.

Remote backup mysql server solution description :

  • Without installing any mysql backup agent software to remote / web mysql database server.
  • Just install MySQL backup software to local computer or laptop.
  • Mysql online backup supports , without interrupting your business or service.
  • Easy of MySQL GUI Backup software.
  • Schedule your backup job on any time you want.

2) . Sycnchronize two MySQL Servers via backup

Two mysql servers sychronization solution description :

  • Creating backup from primary mysql server without interrupting serivice.
  • Restore backup to secondary mysql server.
  • Saving backup to harddisk or sychronize on the fly
  • If primary server fails , the secondary take over the service.
  • Restore backup to secondary server with different database name.
  • You can even sychronize two databases on the same mysql server.
  • More safe solution for you business.

MySQL Backup v6.0.2

mysql backup screenshot
View Screenshot
( 2014.01.17 )

            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

 
Download sql server ,mysql backup  restore software
Subscribe to RSS - MySQL Backup Topics