Encyclopedia > Wikipedia:Database download

  Article Content

Wikipedia:Database download

All Wikipedia content is licensed under the GNU Free Documentation License; see Wikipedia:Copyrights for more info.

See also Wikipedia:PHP script to get the software to run the wiki. If you're just looking for the database schema, it's described in schema.doc (http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/%2Acheckout%2A/wikipedia/phpwiki/newcodebase/docs/schema.doc?rev=HEAD&content-type=text/plain) (a text file, not Microsoft Word; IE users beware).

Database dumps, updated approx. weekly

See http://download.wikipedia.org/ to grab the backup dumps of the database. These can be read into a MySQL relational database for leisurely analysis, testing of the Wikipedia software (http://wikipedia.sourceforge.net/), and with appropriate preprocessing, perhaps offline reading.

The database schema is explained here (http://cvs.sourceforge.net/cgi-bin/viewcvs.cgi/wikipedia/phpwiki/newcodebase/docs/schema.doc?rev=HEAD&content-type=text/vnd.viewcvs-markup). The cur tables contain the current revisions of all pages; the old tables contain the prior edit history. Approximate file sizes are given for the compressed dumps; uncompressed they'll be significantly larger.

Static HTML tree dumps for mirroring or CD distribution

In development... If you'd like to help set up an automatic dump-to-static function, please drop us a note on the developers' mailing list.

Daily tarballs of older Non-English Wikipedias

These have not yet been upgraded and are running on UseMod-wiki. The software and data are included together in a single tarball.

  • ar - Arabian (http://ar.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • ca - Catalan (http://ca.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M)
  • et - Estonian (http://et.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • eu - Euskara (http://eu.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • fi - Finnish (http://fi.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • fy - Frisian (http://fy.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • he - Hebrew (http://he.wikipedia.com/tarballs/wiki.tar.gz) (ca 44k)
  • hu - Hungarian (http://hu.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • ia - Interlingua (http://ia.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • it - Italian (http://it.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.5M)
  • pt - Portuguese (http://pt.wikipedia.com/tarballs/wiki.tar.gz) (ca 2M)
  • sl - Slovenian (http://sl.wikipedia.com/tarballs/wiki.tar.gz) (ca 0.3M) (dead link)
  • (More?)

see also Wikipedia:TomeRaider database

Please do not use a web crawler to download large amounts of articles. Aggressive crawling of the server can cause a dramatic slow-down of Wikipedia.

All Wikipedia text is available under the terms of the GNU Free Documentation License

  Search Encyclopedia

Search over one million articles, find something about almost anything!
  Featured Article
Islip Terrace, New York

... males. The median income for a household in the town is $66,644, and the median income for a family is $69,389. Males have a median income of $51,036 versus $30,714 for ...

This page was created in 38.5 ms