Database dump: Difference between revisions

Revision as of 12:23, 8 January 2020

Latest revision as of 17:39, 24 October 2024

(9 intermediate revisions by 7 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|information on obtaining a database dump of the Wikipedia contents|Wikipedia:Database dump|selfref=yes}}

A '''database dump''' (also: '''SQL 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>.

== See also ==

*[[Import and export of data]]

*[[Core dump]]

*[[Databases]]

*[[Database management system]]

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

* [[Data portability]]

== External links ==