Automatic MySQL Database Backup to FTP, USB, NAS, Online
Automatic MySQL database backup solutions help you stop worrying about risks related to losing valuable data due to hardware failures, human errors, virus attacks, etc.
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.
On this page you can learn about functions of Handy Backup that are helpful when backing up MySQL databases. We also recommend to read general information on the MySQL Database Backup plug-in and how it can be used for backup, recovery and replication.
MySQL Database Backup: Use Cases
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.). Learn more about how to backup Joomla and migrate Drupal. Also to learn our recommendations on safeguarding websites, please see Website Backup.
Version 8.4.0, built on June 30, 2022. 113 MB
Our backup solution for small business 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.
The Open File Backup feature enables you to back up any PC program in "live" mode, even if some of its files are opened exclusively. This lets you back up MySQL-driven software (like CRM, ERP, and other) without interrupting their work.
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, NAS Server Backup, Exchange Server Backup and many other data source plug-ins.
To learn more, please see the Backup Features page.
Best Storage for Your Backups
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.
To learn more about destinations supported by Handy Backup, please see Backup Storage.
MySQL Backup is available in Small Server and Server Network editions. Free trial!
Differential and Incremental MySQL Backup
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 MySQL Backup plug-in in Handy Backup. Differential changes are calculated on byte level, i.e. it is the main way of optimizing size of backups with 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.
For more information on restoring MySQL databases, please refer to MySQL Restore.
Compression, Encryption and Other Options
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:
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!
Scheduled Backup: Strategies
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.
If You Don’t Have MySQL Replication
If You Have MySQL Replication
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!
Handy Backup Small Business
$249 per license
Related to MySQL Backup
Backup Medical Information - check out how to perform medical data backup with MySQL
Hot Backup - back up your SQL databases without stopping them, through the hot backup technology
SQL 2012 Backup - protect data of Microsoft SQL Server using a special plug-in
Website Backup Service - a key feature of any modern backup software
Backup Jira - make Jira backup using the most popular MySQL database engine as a standard Jira database
Backup MariaDB - perform MariaDB backup and recovery with many advanced options
Navicat Database Backup - collate most popular tools for administering databases (as Navicat) with our software
MySQL Workbench Backup - a dedicated MySQL backup software vs the built-in MySQL Workbench backup
Backing up MySQL with Handy Backup
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: