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 queries. 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 released by open source projects, to allow reuse of forking of the database. For example Wikipedia offers its articles in a database dump at download.wikimedia.org. A database is a collection of data elements (facts) stored in a computer in a systematic way, such that a computer program can consult it to answer questions. ... SQL is the most popular computer language used to create, modify and retrieve data from relational database management systems. ... The Wikipedia logo. ...
Databasedumps are no longer prepared in SQL format; they now occur only in XML (for article contents).
Databasedumps are not on an automatic schedule; they are performed when a developer has the time, (and hopefully the site is not overloaded).
If the SQL dumps were available uncompressed, this process should work extremely well, especially if rsync is invoked with the on-the-fly compression switch (-z).
Feeds |
Contact