Wikipedia:Database queries: Difference between revisions

Revision as of 23:09, 20 May 2012

Revision as of 08:25, 6 September 2012

Line 11:

* All [[WP:Red link|red links]] on pages within the scope of a particular [[WP:WikiProject|WikiProject]]

Many simple queries can be run directly using the tools built into the [[MediawikiMediaWiki]] package used by Wikipedia. Some of the most popular and useful queries are run regularly and can be found at [[Wikipedia:Database reports]]. If neither of these suits your query, you can request that someone run a query for you, or download your own copy of the database to work on.

== Using the MediawikiMediaWiki tools ==

Some queries can be satisfied through the MediawikiMediaWiki interface:

* [http://en.wikipedia.org/w/index.php?title=Special:Search&search=&fulltext=Search&profile=advanced&redirs=1 Search in advanced mode]

* [[Special:PrefixIndex|All pages with prefix]]

* [[Special:CategoryTree|Category tree]]

* [http://www.mediawiki.org/wiki/API MediawikiMediaWiki API] (see [[Special:ApiSandbox]])

== Queries that are already run regularly ==

Line 42:

# Download and install [[MySQL]] from [http://dev.mysql.com/downloads/ http://dev.mysql.com/downloads/] if you do not already have a local copy.

# Download the Wikipedia tables you need from [http://download.wikipedia.org download.wikipedia.org]. Details of the database structure can be found in the MediawikiMediaWiki [http://svn.wikimedia.org/viewvc/mediawiki/trunk/phase3/maintenance/tables.sql?view=markup source repository] and [http://www.mediawiki.org/wiki/Manual:Database_layout manual] at mediawiki.org.

# Create a database and import the downloaded table dumps. More instruction on how to do this can be found at [[Wikipedia:Database download]]

# Run your query