Database dump

From Wikipedia, the free encyclopedia
  (Redirected from Data dump)
Jump to: navigation, search
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.

Example[edit]

-- Database
CREATE DATABASE `example`;
USE `example`;
 
-- Table structure for table `users`
CREATE TABLE `users` (
  `id` INT(8) UNSIGNED NOT NULL AUTO_INCREMENT,
  `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[edit]

References[edit]

expdp or impdp or rman in oracle

External links[edit]