Tools for automatic MySQL database Backup-MySQL Backup Tool

MySQL Backup Tool
Backing up a MySQL database is a basic task of database management. Although you can directly back up a database using mysqldump, you still need to do a lot of work to achieve automatic backup. MySQL Backup Tool provides us with support for automated MySQL database Backup.
Features:
MySQL backup (automatic, manual, and scheduled)
Structure/architecture and stored procedure/Function
Compressed to a zip file (including password protection)
Blacklist and whitelist
Table dump
Delete old backup
CPU load balancing
Software Upgrade check

Get Program

The MySQL Backup Tool URL is http://sourceforge.net/projects/mysqlbutool/. you can download it directly. The downloaded file is a zip file mysql backup Release 1.2.1.2.zip. The current version is 1.2.1.2. This program is developed using. NET.
Program Interface

The top three input boxes are used to enter the user name, password, and server name of your MySQL server.
Base Dir for backup is used to specify the directory where the backup file is stored. This software will automatically embed the backup date in the backup file.
Location of mysqldump file is used to specify the directory where the MySQL backup program mysqldump is located. This software directly comes with one.
Use blacklist and use whitelist are used to select whether to use the blacklist or whitelist. If you use the blacklist, the selected database will not be backed up. If a whitelist is used, only the selected database is backed up.
Select from server: Select Db's is used to Select a database. The selected database is displayed in the following input box.

Select a database

The input box after Select Manually is used to Manually enter the name of the used database. Multiple databases are separated by commas.
Then the backup method

 

All db tables in separate files indicates that the database tables are stored in different files.
All db tables in one file per db indicates that All tables in each database are saved in one file.
Both (one file and separated)
You can also specify the Insert mode. If Insert Ignore is selected, it will be inserted directly unless it is already a primary key or a unique constraint in the table. Replace is similar to insert. Except for the original rows in the table, the original row is deleted before the new row is inserted.
If Save Sturcture is selected, the database architecture is saved in a separate file, including the table structure, stored procedures, functions, and triggers. The saved files are as follows:

Check credentials on save settings is used to Check whether you can log on to the database.
Compress to zip is used to specify whether to Compress the backup file, and Password Protected is used to specify whether to use a Password to save the compressed file. The selected user name and password are required.
Two other items are to specify a description name and whether to delete the original backup.
The Save Settings button below is used to Save the configuration parameters.
Create Backup is used to Create a Backup immediately.
Timed backup

In combination with scheduled tasks in Windows, you can also complete timed automatic backup.

 

After startup, you can create a folder to manage MySQL backup tasks.
Create a folder in the task scheduler library.

 

The dialog box is displayed.
 

After creation
 

Then, go to the folder, create a task in it, and select Create task on the right. Note: In the pop-up dialog box, select "execute regardless of whether the user logs in or not" and use the highest permission for execution.

 

Set the backup time and cycle in the trigger.
 

In the operation, select create operation. Note that you must add runatstart to add parameters.
 

Author champion