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 ("SQL dump"). 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 content projects, to facilitate reuse, forking, offline use, and long-term digital preservation.
Dumps can be transported into environments with Internet blackouts or otherwise restricted Internet access, as well as facilitate local searching of the database using sophisticated tools such as grep.
YouTube Encyclopedic
-
1/3Views:7 09560 3601 227
-
How to Backup and Restore MySQL/MariaDB database using mysqldump
-
Exporting and Importing PostgreSQL Databases
-
MySQL Tutorials: How to take dump/backup of more that one databases or all databases in one command
Transcription
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
 | This database-related article is a stub. You can help Wikipedia by expanding it. |
This page was last edited on 2 October 2022, at 04:15