Editing Encyclopedia:Database download (section)

==Where do I get the dumps?==
===English-language Wikipedia===
* Dumps from any Wikimedia Foundation project: {{URL|//dumps.wikimedia.org/}} and the [[iarchive:wikimediadownloads|Internet Archive]]
* English Wikipedia dumps in SQL and XML: {{URL|//dumps.wikimedia.org/enwiki/}} and the [https://archive.org/search.php?query=subject%3A%22enwiki%22%20AND%20subject%3A%22data%20dumps%22%20AND%20collection%3A%22wikimediadownloads%22 Internet Archive]
** [https://meta.wikimedia.org/wiki/Data_dump_torrents#English_Wikipedia Download] the data dump using a BitTorrent client (torrenting has many benefits and reduces server load, saving bandwidth costs).
** pages-articles-multistream.xml.bz2 – Current revisions only, no talk or user pages; this is probably what you want, and is over 19 GB compressed (expands to over 86 GB when decompressed).
** pages-meta-current.xml.bz2 – Current revisions only, all pages (including talk)
** abstract.xml.gz – page abstracts
** all-titles-in-ns0.gz – Article titles only (with redirects)
** SQL files for the pages and links are also available
** All revisions, all pages: '''These files expand to multiple [[terabyte]]s of text. Please only download these if you know you can cope with this quantity of data.''' Go to [//dumps.wikimedia.org/enwiki/latest/ Latest Dumps] and look out for all the files that have 'pages-meta-history' in their name.
* To download a subset of the database in XML format, such as a specific category or a list of articles see: [[Special:Export]], usage of which is described at [[Help:Export]].
* Wiki front-end software: [[MediaWiki]] [//www.mediawiki.org].
* Database backend software: [[MySQL]].
* Image dumps: See below.

===Other Wikipedia editions===

* Wikipedia dumps in SQL and XML: {{URL|//dumps.wikimedia.org/}}