MySQL database backup and recovery
Handy Backup is the perfect solution for MySQL backup and recovery. It allows creating non-blocking snapshots of data, which are taken without interrupting SQL queries and transactions.
With scheduling, an ability to roll back a database to any point in time, and other features Handy Backup is often considered one of the best MySQL backup solutions for Windows and Linux.
Version 7.7.6, built on January 26, 2016 54.2 MB
There are two principal ways in which a MySQL can be backed up:
Handy Backup uses hot backup technology, similar to the one employed in MySQL Enterprise Backup (Oracle’s proprietary software for enterprise editions of MySQL). It works quickly and allows creating automatic backup for particular tables, tablespaces, and entire databases.
Restoration of MySQL can be used for multiple purposes:
To learn more, please refer to MySQL recovery.
Handy Backup features a powerful MySQL Backup that acts like a MySQL client and retrieves data without interrupting the server. Backing up MySQL with Handy Backup doesn’t require to install any additional software. The program is equipped with all plug-ins that can be used during the trial period. You only need to find MySQL in the list, and click Add to select it.
The MySQL Backup option connects to the server and backs up database contents into a dump file. The resulting backup file contains all SQL queries required to reproduce the original database including all tables, tablespaces, stored procedures, functions, and other data.
Here are several top features of MySQL Backup:
Hot Backup and Recovery
The use of advanced hot backup technology lets you protect data without interrupting your web applications and website services!
Partial and Full Backup
The featured utility can back up all database as a whole, or copy any selected database tables. Save time and space of backup by copying only just you need!
Backup of Local and Networked Databases
You can back up MySQL database stored not only on your local machine, but on any remote computer on the network.
Preserving Native Data Format
Make copies with Handy Backup and then process these copies with any software you wish to apply, as Handy Backup does not change format or attributes of data it backs up.
To learn about other things you can do to your MySQL database with Handy Backup, please see MySQL Database Backup.
In addition to the plug-in described above, our software also has a general Database Backup plug-in that can be used to export tables through ODBC connectivity. This plug-in lacks support for certain MySQL objects (e.g. stored routines) and requires you to install ODBC Driver for MySQL which you can download from the official MySQL website.
To learn more about this plug-in, please refer to ODBC backup.
Handy Backup is a reliable MySQL backup tool that enables you to completely automate everything related to protection of your databases, websites and MySQL-driven applications!
The idea of replication implies that you share database contents between multiple physical or virtual MySQL servers (nodes), in order to improve your application’s performance, security, and other critical parameters. To a certain extent, replication resembles clustering: if one node crashes, this doesn’t lead to failure of the entire website or application. While replication is a good security measure, it is important to understand that it can’t replace backups.
Since it is usually performed in real time, dropping (deleting) a database on master server will repeat the same operation on slave servers, resulting in loss of data.
The same is valid for MySQL mirroring which is basically the same as master-to-master replication.
MySQL replication requires copying master database to different servers, and configuring these servers to act as MySQL Slaves.
Here is a common scenario, where Handy Backup can be of great help:
Note: Changing storage engine is a general recommendation for any master-to-slave replication configuration. MySQL Slave servers are supposed to be read-only, and setting MyISAM as a storage engine greatly improves their performance.
For more details on replication and setting up combination of replication and backup, please refer to MySQL replication.
Version 7.7.6, built on January 26, 2016. 54.2 MB Backup Software from Novosoft LLC. 249 USD per license.
To back up and restore your MySQL databases, you need to use the Handy Backup Small Server edition. Free 30-days trial version!
See other purchase options
The MySQL Backup feature is available in two editions of Handy Backup: Small Server and Server Network. Both editions are equipped with full sets of features, the only difference is that the Small Server edition is designed to back up one computer, while the Server Network edition enables you to back up several servers on the network.
In the following video tutorial you can learn how to back up and restore MySQL databases with Handy Backup.
Note: Instructions in this video suggest that you already have Handy Backup installed on your computer. If you still haven’t done so, don’t hesitate to download it.
We are open for cooperation with business partners from all fields of IT industry, including OEM, technological integrators, service providers, and other. Partnership details are discussed individually, in respect of each partner’s resources and expertise.
As regards MySQL backup, Handy Backup solutions are already employed by a number of web hosting providers who use it to back up client websites and databases. If you would like to join our partner network or learn more about how we can help your business, please visit the Partners section.
MySQL backup speed is great. For MySQL is Excellent, Super Fast, Super Easy! For now we are planning to recommend Handy Backup to our customers.
Feedback from Johnny Cosme Lewis, www.HostSeven.comMore Feedback
Cnet Editor’s Rating:
Loading comments, please wait...
It`s nice Handy Backup can do Windows back up, as well as Outlook Mail. Great backup software. Has been using this application for years now.
So I can back up a part of data, right?
Right, it`s possible to do the partial backup, and that is pretty convenient.В
I didn`t hear it`s possible to back up MySQL, I`ll try Handy.В
MySQL backup is possible with Handy Backup.
Copyright © 2004-2016 Novosoft LLC. All rights reserved. Handy Backup software.
Back to Top