This article does not cite any references or sources. Please help improve this article by adding citations to reliable sources. Unsourced material may be challenged and removed. (March 2007) 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 statements. 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 software and free content projects to allow reuse or forking of the database. Contents 1 Example 2 See also 3 References 4 External links Example -- Database CREATE DATABASE 'example'; USE 'example'; -- Table structure for table 'users' CREATE TABLE 'users' ( 'id' INT(8) UNSIGNED NOT NULL AUTOINCREMENT 'username' VARCHAR(16) NOT NULL 'password' VARCHAR(16) NOT NULL PRIMARY KEY ('id') ); -- Data for table 'users' INSERT INTO 'users' VALUES (1'alice''secret')(2'bob''secret'); See also Core dump Databases Database management system References The template below (Empty section) is being considered for deletion. See templates for discussion to help reach a consensus. This section is empty. You can help by adding to it. External links mysqldump A Database Backup Program PostgreSQL dump backup methods for PostgreSQL databases. v d eDatabase management systems Database models  Database normalization  Database storage  Distributed DBMS  Federated database system  Referential integrity  Relational algebra  Relational calculus  Relational database  Relational DBMS  Relational model  Object-relational database  Transaction processing Concepts Database  ACID  CRUD  Null  Candidate key  Foreign key  Primary key  Superkey  Surrogate key  Armstrong's axioms Objects Relation (Table)  View  Transaction  Log  Trigger  Index  Stored procedure  Cursor  Partition Components Concurrency control  Data dictionary  JDBC  ODBC  Query language  Query optimizer  Query plan Database products: Object-oriented (comparison)  Relational (comparison)  Document-oriented

This database-related article is a stub. You can help Wikipedia by expanding it.v d e