Database dump: Difference between revisions

Revision as of 13:58, 10 December 2009

Latest revision as of 17:39, 24 October 2024

(48 intermediate revisions by 33 users not shown)

Line 1:

{{Short description|Record of the table structure and/or the data from a database}}

{{Unreferenced|date=March 2007}}

{{No footnotes|date=October 2022}}

:''For {{for|information on obtaining the Wikipediaa database, seedump of the Wikipedia [[contents|Wikipedia:Database download]].''dump|selfref=yes}}

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 ("SQL dump"). 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 allowfacilitate reuse or, [[Fork (software development)|forking]], ofoffline theuse, databaseand long-term [[digital preservation]].

Dumps can be [[data portability|transported]] into environments with [[Internet blackout]]s or otherwise restricted Internet access, as well as facilitate local searching of the database using sophisticated tools such as <code>[[grep]]</code>.

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

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.

== See also ==

*[[Import and export of data]]

*[[Core dump]]

*[[Databases]]

*[[Database management system]]

*[[SQLyog]]- MySQL GUI tool to generate Database dump

* [[Data portability]]

==References==

== External links ==

*[http://dev.mysql.com/doc/refman/5.0/en/mysqldump.html mysqldump — A Database Backup Program]

*[http://www.postgresql.org/docs/8.2/interactive/backup-dump.html PostgreSQL dump backup methods], for [[PostgreSQL]] databases.

[[Category:Databases|*]]

{{databases}}

[[Category:Database administration toolstheory]]

[[Category:Database administration tools]]

{{database-stub}}

[[de:Datenbankdump]]