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:

Please download and install the software Automatic Backup Scheduler for MySQL.

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.

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

1. Compress the SQL backup files to a ZIP ( *.ZIP ) file with password.
Enter the password if you want.

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.

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

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.