# Database dump

> Mediated Wiki article. Canonical URL: https://mediated.wiki/source/Database_dump
> Markdown URL: https://mediated.wiki/source/Database_dump.md
> Source: https://en.wikipedia.org/wiki/Database_dump
> Source revision: 1253169524
> License: Creative Commons Attribution-ShareAlike 4.0 International (https://creativecommons.org/licenses/by-sa/4.0/)

Record of the table structure and/or the data from a database

This article includes a list of references, related reading, or external links, but its sources remain unclear because it lacks inline citations. Please help improve this article by introducing more precise citations. (October 2022) (Learn how and when to remove this message)

For information on obtaining a database dump of the Wikipedia contents, see [Wikipedia:Database dump](https://en.wikipedia.org/wiki/Wikipedia:Database_dump).

A **database dump** contains a record of the [table](/source/Table_(database)) structure and/or the data from a [database](/source/Database) and is usually in the form of a list of [SQL](/source/SQL) statements ("SQL dump"). A database dump is most often used for [backing up](/source/Backup) a database so that its contents can be restored in the event of [data loss](/source/Data_loss). [Corrupted](/source/Data_corruption) databases can often be recovered by analysis of the dump. Database dumps are often published by [free content](/source/Free_content) projects, to facilitate reuse, [forking](/source/Fork_(software_development)), offline use, and long-term [digital preservation](/source/Digital_preservation).

Dumps can be [transported](/source/Data_portability) into environments with [Internet blackouts](/source/Internet_blackout) or otherwise restricted Internet access, as well as facilitate local searching of the database using sophisticated tools such as [grep](/source/Grep).

## See also

- [Import and export of data](/source/Import_and_export_of_data)

- [Core dump](/source/Core_dump)

- [Databases](/source/Databases)

- [Database management system](/source/Database_management_system)

- [SQLyog](/source/SQLyog)- MySQL GUI tool to generate Database dump

- [Data portability](/source/Data_portability)

## External links

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

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

This database-related article is a stub. You can help Wikipedia by adding missing information.

- [v](https://en.wikipedia.org/wiki/Template:Database-stub)
- [t](/source/Template_talk%3ADatabase-stub)
- [e](https://en.wikipedia.org/wiki/Special:EditPage/Template:Database-stub)

---
Adapted from the Wikipedia article [Database dump](https://en.wikipedia.org/wiki/Database_dump) by Wikipedia contributors ([contributor history](https://en.wikipedia.org/wiki/Database_dump?action=history)). Available under [Creative Commons Attribution-ShareAlike 4.0 International](https://creativecommons.org/licenses/by-sa/4.0/). Changes may have been made.