Database dump: Difference between revisions

Revision as of 09:40, 17 February 2015

Revision as of 10:52, 29 May 2015

Line 3:

A '''database dump''' contains a record of the [[Table (database)|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 [[backup|backing up]] a database so that its contents can be restored in the event of [[data loss]]. [[Data corruption|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 [[Fork (software development)|forking]] of the database.

== Example ==

<source lang="sql">

-- Database

CREATE DATABASE `example`;

USE `example`;

a place where you can trow shith

-- 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');

</source>

== See also ==