Database dump

From Wikipedia, the free encyclopedia

For information on obtaining the Wikipedia database, see Wikipedia:Database download.

A database dump contains a record of the table structure and/or the data from a database and is usually in the form of a list of SQL queries. 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 open source projects, to allow reuse or forking of the database.

[edit] See also

• Core dump
• Databases
• Database management system

[edit] References

[edit] External links

• mysqldump — A Database Backup Program

Topics in database management systems (DBMS) ( view • talk • edit )
Concepts Database • Database model • Relational database • Relational model • Relational algebra • Primary key, Foreign key, Surrogate key, Superkey, Candidate key • Database normalization • Referential integrity • Relational DBMS • Distributed DBMS • ACID
Objects Trigger • View • Table • Cursor • Log • Transaction • Index • Stored procedure • Partition	Topics in SQL Select • Insert • Update • Merge • Delete • Join • Union • Create • Drop
Implementations of database management systems
Types of implementations Relational • Flat file • Deductive • Dimensional • Hierarchical • Object oriented • Temporal • XML data stores	Components Query language • Query optimizer • Query plan • ODBC • JDBC
Database products
Apache Derby • Berkeley DB • Caché • DB2 • db4o • DBase • eXtremeDB • Filemaker Pro • Firebird • Greenplum • H2 • Helix • Informix • Ingres • InterBase • Linter • Microsoft Access • Microsoft SQL Server • Mimer SQL • MonetDB • MySQL • Objectivity/DB • OpenLink Virtuoso • OpenOffice.org Base • Oracle • Oracle Rdb • Paradox • Perst • PostgreSQL • SQLite • Sybase IQ • Sybase • Teradata • UniVerse • Visual FoxPro Other: Object-oriented (comparison) • relational (comparison)