MySQL Administrator is a visual administration console for MySQL, it allows you easily manage and maintain your MySQL environment. But if you want to back up or restore your databases, you need a more professional MySQL backup and recovery software.
Automatic Backup Scheduler for MySQL is an professional automated MySQL backup and recovery software. It can be used to back up MySQL database to the SQL files, the other MySQL server or database on schedule. It will automatically compress and password MySQL backup files and upload them to your FTP server or Email box. With MySQL Backup Command Line Program, you can run the task manually. And it provides Windows Service function to run the tasks on schedule in the background.
Features | Automatic Backup Scheduler for MySQL | MySQL Administrator |
---|---|---|
Back up MySQL databases to the other server directly | ||
Back up a MySQL database to the other database directly | ||
Upload the backup files to FTP | ||
Upload the backup files to Email Box | ||
Send error report to Email Box | ||
Compress the backup files such as ZIP or GZIP | ||
Windows Service for scheduling backing up without any users logged in Windows | ||
Back up and restore MySQL databases by Command Line Program | ||
Back up the newly-created and updated items | ||
Automatically delete the expired backup files | ||
Task Logs | ||
Records the backup files history for recovery | ||
Choose to Back up Tablespaces or not | ||
Back up and restore all items of MySQL ( Tablespaces, Databases, Tables, Views, Triggers, Stored Procedures, Functions, Events, Indexes, Primary Keys, Foreign Keys, etc. ) | ||
Full, Incremential and Differential Backup | Only Full Backup | |
Protocols for Connecting MySQL | TCP/IP, SSL, SSH, Compression, Shared-Memory, Named Pipe, Socket | TCP/IP, SSL, Compression |
Professional Task Scheduler | Minutely, Daily, Weekly, Monthly, and very Powerful | Only Daily, Weekly, Monthly and too Simple |
User friendly GUI | ||
Back up and restore all character sets of MySQL ( Unicode, UTF8, etc. ) | ||
Back up and restore all store engines of MySQL ( InnoDB, MyISAM, BDB, etc. ) | ||
Back up and restore all field types of MySQL ( BLOB, TEXT, VARCHAR, DATE, DECIMAL, etc. ) | ||
Select databases from the SQL files when recovery (Reverse Parse) | ||
Unlimited number of databases and servers | ||
Features | Automatic Backup Scheduler for MySQL | MySQL Administrator |