Automatically make backup of MySQL databases and compress them to GZIP / ZIP archives with password to reduce disk usage and protect the important data.
Tutorials
Automatic Backup Scheduler for MySQL > Tutorials > How to back up MySQL database to GZIP / ZIP with password automatically?

How to back up MySQL database to GZIP / ZIP with password automatically?


Do you still back up your important MySQL databases manually? As your MySQL databases grow larger and larger, the backup files take up more and more disk space. Meanwhile, the SQL backup files without any protection, everyone can open and get your important and confidential data. Don't you want to protect your important data? So, you need an assistant to help you back up, compress and encrype your MySQL databases on schedule.

Automatic Backup Scheduler for MySQL is an easy-to-use and professional automated MySQL backup and recovery software. It can be used to automatically compress and password MySQL backup files to ZIP / GZIP archives.

Please follow the steps to automatically make the backup of your MySQL databases and compress it to GZIP (*.gzip) or ZIP (*.zip) with password:

Step 1: Download and install the software.
Please download and install the software Automatic Backup Scheduler for MySQL.



  1. Runs under Windows 8/7/2008 Server/Vista/2003 Server/XP/2000 (32 bit and 64 bit).
  2. Supports MySQL from 4.0 to the latest version (MySQL 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 6.0, etc.).
  3. Supports MySQL servers run on all Operating Systems (Linux, UNIX, Windows, Ubuntu, etc.).

Step 2: Launch the software and create a task to Back up MySQL databases to the SQL files.
  1. Launch the software Automatic Backup Scheduler for MySQL.
  2. Create a task to Back up MySQL databases to the SQL files.
  3. Enter the name of the task and the information of the source MySQL server.
  4. Select the databases which you want to back up.

Step 3: Choose the option Compress the backup files.
Please choose the option Compress the backup files and click Settings... to set up the compression options on Step 4 of the Task Wizard.
Compression Options

Step 4: Set up the compression options.
1. Compress the SQL backup files to a ZIP ( *.ZIP ) file with password.
Enter the password if you want.
ZIP
  1. Compression Format: Please choose the ZIP format.
  2. Compression Level: Lower level gives faster speed but lower compression rate and higher level gives higher compression rate but slower speed. The default value is recommended.
  3. Encryption: The encryption algorithms, including ZIP Compatible, WinZip AES 128, WinZip AES 192 and WinZip AES 256.
  4. Password: If you choose the option Encryption, the password is required. Please remember the password you set. You have to enter it when extract the backup files.
  5. Self Extracting: If you choose the option, the compressed file will be an executable file ( *.exe ). It means you can extract the SQL file without UNZIP program.
2. Compress the SQL backup files to a GZIP ( *.GZ ) file. The GZIP achive can't be encrypted.
GZIP

After changing the compression options please click OK to save them.

Step 5: Click Next and follow the Task Wizard to finish the task creation.
Please click Next and choose the Task Scheduler for running the task on Step 7 of Task Wizard to back up the MySQL databases on schedule.


Click Finish on Step 8 of Task Wizard to finish the task creation.

That's all. The software will automatically back up the MySQL databases to a GZIP ( *.GZ ) or ZIP ( *.ZIP ) file with a password, you don't need to manually back up, compress and encrypt your MySQL databases again.

Enjoy it now!




  1. Runs under Windows 8/7/2008 Server/Vista/2003 Server/XP/2000 (32 bit and 64 bit).
  2. Supports MySQL from 4.0 to the latest version (MySQL 4.0, 4.1, 5.0, 5.1, 5.5, 5.6, 6.0, etc.).
  3. Supports MySQL servers run on all Operating Systems (Linux, UNIX, Windows, Ubuntu, etc.).
Copyright © 2017 Database Think Software. All rights reserved.