Backup Software / Backup Terms Glossary / Databases / 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:
For MySQL databases, all of the above operations can be made with the help of Handy Backup. The MySQL Backup 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...
Version 7.20.0, built on 20 December, 2018. 164 MBBackup Software from Novosoft LLC. 249 USD per license.
The Small Server edition of our program 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.
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!
Version 7.20.0, built on 20 December, 2018
See all terms from Databases...
Backup Terms 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 179 terms. The current section Databases contains 18 terms.
Copyright © 2004-2019 Novosoft LLC. All rights reserved. Handy Backup software.
10685-B Hazelhurst Dr., Houston, TX 77043, United States Tel.: +1 (707) 703-13-11
Back to Top