Database dump is a text file containing a set of SQL statements that need to be run on an SQL server to create a database with the entire internal structure and fill it up with values. Basically, it is a type of backup that is made on "logical" level and can be used to restore database contents after a data loss event.
Unlike "physical" backup of the DBMS binary files (that are exclusively used by server and can′t be copied without stopping it), database dump is created via interfaces provided by the database.
Generally, a database dump can be used for several purposes:
List of Supported Databases
Handy Backup performs backups using plug-ins for such database as Oracle, MS SQL, MySQL, PostgreSQL, Lotus Notes/Domino, IBM DB2 etc.
For MySQL databases, all of the above operations can be made with the help of Handy Backup. The MySQL plug-in employed in our software allows making MySQL dump snapshots which can be restored without interrupting the server′s operation. Learn more about MySQL Backup Tool...
The Handy Backup Small Business allows creating MySQL database dumps, as well as backing up Oracle, IBM DB2, MS SQL and other databases. Download full-featured trial version - it′s free!
As compared to backup of binary files, database dumps have several advantages:
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.
Version 8.5.0 , built on September 19, 2023. 116 MB
30-day full-featured trial period
Our software has a number of advanced plug-ins designed for backup and recovery of different databases. While all of them support hot backup, there is only one, MySQL Backup, which can create database dump files. We welcome you to try it right now - it′s easy to set up and use!