If you have a blog or a regular website which makes use of a database to store information, there could be times when the database crashes or for that matter your hosting provider does. In such cases, having backups of your MySQL database is really very very important.
Of course there are several ways to backup your MySQL data, however, most of those require manual intervention and can be easily forgotten.
Auto Backup for MySQL is a MySQL Backup Solution which allows users to schedule the backing up and restoring of your remote and local MySQL Database. Auto Backup for MySQL allows you to create different tasks to backup or restore MySQL database. You can choose to automatically backup MySQL database to SQL files or also choose to upload them another server or to another database altogether.
In addition to the above tasks you can also export the MySQL tables to CSV, XML, HTML or Text files and execute regular MySQL queries on the database.
Once you choose a task, the software will walk you through a wizard which will create the steps required to perform the task. For detailed instruction on creating a task using Auto Backup for MySQL you can visit this post.
Techie Buzz Verdict
Considering that the database is the most important part of any website or blog, Auto Backup for MySQL is definitely a useful software. Using the software you can schedule backups to occur at regular intervals, thus ensuring that you have backups in case your database or host crashes.
However, the only problem I saw with the software is that it expects that the host allows connection from external IP address, whereas many servers come with installations which restrict database access to only local machine. It would be good if the software could allow for SSH tunneling through which it could backup the database too.
Auto Backup for MySQL is available as a free trial for 15 days, after which you can buy different editions of the software starting at $59.95.
Download Link: http://www.swordsky.com/
Pro Link: http://www.swordsky.com/pro_edition.html
This is a sponsored review of the software, all views in the post are unbiased and true.