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...
Version 8.4.6, built on April 25, 2023. 116 MB
Small Business Backup Solutions
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!
Database Dump vs Cold Backup
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.4.6, built on April 25, 2023
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!
Term of the Day
Backup Software Glossary
Current glossary explains various terms that you may come across while working with Handy Backup or other backup software.
Handy Backup is a backup utility for Windows Servers and PCs that is famous for its flexibility and ease of use.
The glossary contains 111 terms. The current section Databases contains 16 terms.
Other “Databases” Terms