GuildWiki:Database dumps

Below are off-site links to the GuildWiki's database dumps. These are very large XML files. If you don't already know how to use them, you're probably not interested in them.

Because this article contains trusted off-site links, it is protected from editing by normal users. Feel free to suggest changes in the talk page.

How to create a local mirror of GuildWiki
The following assumes that you know how to install and setup MediaWiki, MySQL, PHP as well as the web server under which MediaWiki runs (typically, Apache).

Basic procedure (Unix-only, as the image filenames contain names that windows cannot handle):


 * 1) Install and setup the MediaWiki software.  When you do this, you must set the mediawiki "Site Name" ($wgSitename) to "GuildWiki".  If you do not do this, some GuildWiki pages will not be accessible (example: the "Community portal" link will not work).
 * 2) Download and uncompress the GuildWiki dump.  Most people will want the "All articles" dump.  The following instructions will use the filename, "/tmp/gwiki_cur", as the name of the file that contains the uncompressed dump.
 * 3) Download the .zip file that contains the images for the dump, but do not yet extract the images.
 * 4) Make sure that MySQL has been started.  Also make sure that "AdminSettings.php" in the top-level MediaWiki directory contains the name and password of a MySQL user that can create databases (e.g., "root", if you're doing a private installation and are aware of the security issues).  If this file does not exist, use "AdminSettings.sample" as a template, and fill in the name and password.
 * 5) cd to the top-level MediaWiki directory, and run the command:     php maintenance/importDump.php < /tmp/gwiki_cur Note that this will take several hours to run.  Also, do not extract the image files before doing this step; doing so will cause importDump.php</tt> to take several more hours to run, because it will attempt to create all image thumbnails during the import.
 * 6) Now that the database import has finished, extract the images into the MediaWiki "images</tt>" subdirectory.  Note that you must preserve the directory structure in the images .zip</tt> file (don't give the "-j</tt>" option to unzip</tt>).
 * 7) Run the following commands in the top-level MediaWiki directory (e.g., if you're still in the "images</tt>" subdirectory, do "cd ..</tt>"):     php maintenance/rebuildImages.php    php maintenance/rebuildImages.php --missing    php maintenance/rebuildtextindex.php</tt> The first command will run very quickly (and may not be necessary), but the other commands will take several minutes to over a half-hour to run.
 * 8) Install the ParserFunctions extension.
 * 9) Start your webserver, if necessary, and browse to your MediaWiki/GuildWiki Main Page. Note that the GuildWiki Main Page will not be displayed; you will see the default MediaWiki Main Page, instead.  This is because the MediaWiki Main Page gets an "edit date" of when you installed MediaWiki, which will be later than the last "edit date" of the GuildWiki Main Page, and so the MediaWiki one will be displayed.
 * 10) To restore the GuildWiki Main Page: click on the "History" tab of the Main Page (not the "Edit" tab).  On the resulting page, click on the date of the bottommost history line (there should be only two).  This will temporarily display the old GuildWiki Main Page.  To make it permanently displayed, click on the "Edit" tab, and, once the edit page is displayed, click on "Save Page", near the bottom of the page.
 * 11) That's it.  Your local GuildWiki copy should now be functional.  Note, however, that displaying pages can be slow; this because, the first time a page is displayed, MediaWiki must render and cache certain parts.  Subsequent displays of the same page should be faster.

Complete dumps
These dumps contain all revision history, and thus are suitable for forking the GuildWiki or other public uses.


 * Latest dumps (pages_full.xml.gz) - latest full dumps for the Gamewikis wikis can be found here (after Sept 27, 2007).
 * All articles with all revisions as of September 27, 2007
 * Compressed size: ~213 MB
 * Build articles as of May 1, 2007
 * Compressed size: ~30 MB
 * Uncompressed size: ~780 MB
 * This file includes all the builds that were once hosted on GuildWiki. This snapshot was taken right before the builds wipe.

Current revision dumps
These dumps contain only the most current revision of an article, and so are only usable privately. One could set up a personal MediaWiki installation on their own computers to maintain access to the GuildWiki even without an Internet connection.


 * Latest dumps (pages_current.xml.gz) - latest current revision dumps for the Gamewikis wikis can be found here (after Sept 27, 2007).
 * All articles with current revisions only as of September 27, 2007
 * Compressed size: ~35 MB
 * Build articles with current revisions only as of May 1, 2007
 * Compressed size: ~6 MB
 * Uncompressed size: ~30 MB

Image archives

 * Images as of September 27, 2007
 * Compressed size: ~1.25 GB
 * Archive as of May 1, 2007 for Unix-like systems
 * Compressed size: ~700 MB
 * Uncompressed size: ~800 MB

Note: See http://www.tanatopia.net/gwiki/ for a complete pre-Wikia listing of gamewikis dumps.