Auto MySQL backup
Handy Backup / Features / MySQL Database Backup
Automatic MySQL database backup solutions help you stop worrying about risks related to losing valuable data due to hardware failures, human errors, virus attacks and other disasters. The concept is simple, but when it comes to practice, it is often unclear what features software should have to make backup routines solid, reliable, and easy to set up and manage.
Handy Backup has a long history of success in fulfilling the needs of different clients, from individual computer users to Fortune 500 enterprises. If you are looking for a powerful MySQL backup tool with built-in encryption, incremental backup, scheduling and dozens of other features out of the box – then Handy Backup is right for you.
Version 7.4.5, built on November 19, 2013
22.8 MB, 32-bit (above) or 28.9 MB, 64-bit version
On this page you can learn about functions of Handy Backup that you will find helpful when backing up MySQL databases. We also recommend you to read general information on the MySQL Database Backup plug-in and how it can be used for backup, recovery and replication: to do it, please refer to MySQL Backup.
Since most business applications rely heavily on databases, and MySQL is one of the most popular DBMS in the industry, careful management of MySQL backups is a critical part of many disaster recovery strategies.
Webmasters rarely work directly with the server where their website is located. Instead, they are usually granted access to a number of folders via FTP or SSH and to a content management system (CMS). In this scenario, backing up a website suggests that you back up FTP folder and MySQL database:
This scheme should work for most CMS (Wordpress, Drupal, Joomla, etc.). To learn more about safeguarding websites, please see Website Backup.
Version 7.4.5, built on November 19, 2013. 22.8 MB, 32-bit (above) or 28.9 MB, 64-bit versionBackup Software from Novosoft LLC. 199 USD per license.
The Small Server edition of our software will help you easily back up and restore your MySQL database, website or application. Try free for 30 days!
There are many business applications that are based on MySQL databases and have no internal backup mechanisms. In many cases stopping such applications results in a huge loss of productivity – and this is where third party solutions like Handy Backup prove their worth.
If you develop a product or a service that uses databases, e.g. provide web hosting services, then you should consider trying Handy Backup to improve competitiveness your business. To learn about partnership opportunities, please refer to the Partners section.
In addition to corporate websites and business applications, your servers may manage many other mission-critical domains, from common document archives to customer databases and e-mail servers.
Handy Backup has many great features designed for protecting business data on both “physical” and “logical” levels: these include Disk Image Backup, Exchange Server Backup and many other data source plug-ins. To learn more, please see the Backup Features page.
If backups can’t be restored in reliable manner, they are worthless. This is why it is so important to select the most cost- and performance-effective storage for your data. When a disaster strikes, the “time is money” mantra receives its most concrete and meaningful expression: losses incurred during downtime tend to grow geometrically.
If you would like to learn more about destinations supported by Handy Backup, please see Backup Storage.
MySQL Backup is available in Small Server and Network Server editions. Free trial!
In commercial environments databases grow rapidly and may occupy hundreds of gigabytes of disk space. To reduce costs, the software must allow creating backups in the most efficient way. In Handy Backup, there are a number of advanced options and two main optimization techniques:
It is important to understand how these two methods work with the MySQL Backup plug-in in Handy Backup. Incremental backup is performed on file level, and since there’s no way to estimate size and modification time of database tables, the plug-in always thinks that they were changed and copies them completely. Differential changes are calculated on byte level, i.e. it is the main way of optimizing size of backups with Handy Backup.
For more information on restoring MySQL databases, please refer to MySQL Restore.
The main difference between professional backup software and hand-written scripts is that the software comes with many useful features out of the box. Here are some of the options employed by Handy Backup:
Data stream path: from MySQL database to storage media
There are many other functions that can be of great help when backing up MySQL databases. We welcome you to download our software and see them yourself!
To back up, restore, or synchronize data with Handy Backup, you need to create the respective task. Each task can be started manually, or scheduled to take place automatically. Below you can find general guidelines for setting up automated MySQL backups.
With MySQL replication, the main danger you should worry about is human mistakes, i.e. the risk of corrupting master database by wrong actions. The recommendations are as follows:
For more information on replication, please refer to MySQL Replication.
Do remember, that no backup strategy can guarantee 100% safety, and it is important to control how your data is backed up. In Handy Backup, you can enable e-mail notifications that will send you a letter each time your MySQL database backup task finishes. This is the easiest way to ensure that your backup routine works as intended, and its big advantage is that you can do it remotely, without having to approach the server.
In the following video you can learn how to back up MySQL with Handy Backup. While it doesn’t show many options available in the program, the process of backup and restore is shown very clearly. In this example we use MySQL version 5.5.16 and Handy Backup version 7.3.0.
Handy Backup is a professional tool for local and remote MySQL backup!
Loading comments, please wait...
+1 (707) 703-13-11
Upgrade to version 7
See all volume order prices
2013/12/02 - Hurry Up! The Lucrative Cyber Monday Deal is Right Here!
2013/11/27 - Huuuge Discounts and Even Better Quality! Our Black Friday Offer
2013/11/21 - New Version 7.4.5 Improves Server and Network Capabilities
Database Backup - learn about different approaches to backup and restoration
Hot Backup - back up your SQL databases without stopping them, through the hot backup technology
MS SQL Backup - protect data of Microsoft SQL Server using a special plug-in
SQL Backup Script - read why Handy Backup is better than handmade SQL backup scripts
Since the legendary version 6.9.5, Handy Backup features a special MySQL Backup plug-in which works faster and delivers much more accurate results than backing up through the ODBC driver.
To back up MySQL, follow these steps:
Here are some important features useful for MySQL Backup. Automatic MySQL backup - the software has a flexible scheduler to automate all backup related operations. Selective backup and recovery - you can copy a database as a whole, or make a backup of one separate database table. Backup of local and remote bases - Handy Backup is able to back up both local and networked databases. Hot MySQL backup - our advanced technology allows you to back up your data without stopping the database operation, which is extremely useful if a database is constantly in use. Encryption, compression and other advanced features... Note: If you are using any additional backup software, like BackupAssist, it is recommended to uninstall it due to technical reasons. The simultaneous use of Handy Backup and BackupAssist may cause errors during backup and restore process. Handy Backup is a professional tool for local and remote MySQL backup!
Copyright © 2004-2013 Novosoft LLC. All rights reserved. Handy Backup software.
Back to Top