A database dump contains a record of the
table structure and/or the data from a
database
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and a ...
and is usually in the form of a list of
SQL statements ("SQL dump"). A database dump is most often used for
backing up a database so that its contents can be restored in the event of
data loss.
Corrupted databases can often be recovered by analysis of the dump. Database dumps are often published by
free content projects, to facilitate reuse,
forking, offline use, and long-term
digital preservation
In library science, library and archival science, digital preservation is a formal process to ensure that digital information of continuing value remains accessible and usable in the long term. It involves planning, resource allocation, and appli ...
.
Dumps can be
transported into environments with
Internet blackouts or otherwise restricted Internet access, as well as facilitate local searching of the database using sophisticated tools such as
grep.
See also
*
Import and export of data
*
Core dump
In computing, a core dump, memory dump, crash dump, storage dump, system dump, or ABEND dump consists of the recorded state of the working Computer storage, memory of a computer program at a specific time, generally when the program has crash (com ...
*
Databases
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and ana ...
*
Database management system
In computing, a database is an organized collection of data or a type of data store based on the use of a database management system (DBMS), the software that interacts with end users, applications, and the database itself to capture and an ...
*
SQLyog- MySQL GUI tool to generate Database dump
*
Data portability
External links
mysqldump — A Database Backup Program
for PostgreSQL databases.
*
Database theory
{{database-stub