Backup Software / Backup Terms Glossary / Databases / Database Dump

Database Dump

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:

Backup – to restore data in case of a disaster
Replication – to set up Slave servers and improve database-based application′s performance and stability
Migration – to test how hard it is to migrate to a different database management system
Experiments – to modify the dump and test various configurations

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...

Download

Compare

Version 8.4.6, built on April 25, 2023. 116 MB
Backup Software from Novosoft LLC. 249 USD per license.

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:

Hot backup. In commercial environments, each minute of server downtime may incur thousands of dollars in direct and indirect losses. The hot backup technology implies that the backup can be made in live mode, without pausing the server.
Easily editable. Database dumps have a very clear format that is easy to read and edit. Each file begins with a CREATE TABLE and continues with a number of INSERT statements, i.e. contains everything required to restore the database to a fresh DBMS installation. The simplicity of the format allows for a number of various use scenarios. For example, if you are using MySQL, you can change the database′s storage engine to MyISAM, restore it to a different server, and thus prepare everything for a Master-to-Slave replication configuration. Learn more about MySQL replication...
Can be used for migration. All relational databases are more or less compliant with the SQL standard. Database dumps contain SQL statements that should be accepted by other database management systems without errors. You can find general recommendations on migration from MySQL to other DBMS on the MySQL Recovery page...

Video Example

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.

Free Download

Version 8.4.6, built on April 25, 2023
116 MB

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!

See also:

See all terms from Databases...

Backup Terms Glossary

Contact Us

support@handybackup.net

Term of the Day

Schedule Backup at Shutdown or Logoff
“You can manage Handy Backup to run any backup task when log off the computer. This way, the system will perform the selected task before shutting...”

Backup Software Glossary

Current glossary explains various terms that you may come across while working with Handy Backup or other backup software.

Download

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

Physical Backup
“Physical backup is a copy of an application’s binary files that is performed on hard drive level using common file system queries, rather than...”
Database Replication
“ Database replication is a process of synchronization in which data added to one database is automatically copied to the other. Replication should...”
Shared-Nothing Architecture
“Shared-nothing architecture (SNA) is a pattern used in distributing computing in which a system is based on multiple self-sufficient nodes that have...”