Talk:Database download
Wikia - creating communities
This page needs to be changed when ever Wikia changes the location of its backups. Since Ive been admin of Wikihowto, the dbdump location has changed twice. We need to be able to find where the backups are and this is the place to do it. (Wikihowto has made a howto for this as well 1). The method shown on the current Database download page is inacurate, and needs updating. I will fix what i can but I don't know where the image backup is! ZyMOS 22:15, 1 November 2007 (UTC)
Dump Images Image backups are available at http://images.wikia.com/<database name>/images/images.tar does not work
--> Worked for me and capoeira.wikia.com. Do we let the "does not work" ?
--> Image dump doesn't work on en: uncyclopedia but does work for some of the others.
--MetOSX 10:12, 28 November 2007 (UTC)
- Surely it must be an error so I will remove it and if the problem persist on other wikis, Please add it back...--Cometstyles 11:40, 28 November 2007 (UTC)
Contents |
[edit] DBDumps link broken
The link to http://wikistats.wikia.com/dbdumps/dbdumps.html no longer works. Does anybody know an updated link? -- Sekoia 19:50, 15 December 2007 (UTC)
- Hey! It's working now. :) -- Sekoia 04:49, 25 December 2007 (UTC)
[edit] not every wiki is in database list?
Hello and where can I get the database of w:c:ru.mybyways wiki? Pavel Nedrigailov 04:28, 13 January 2008 (UTC)
Try: wget http://wikistats.wikia.com/dbdumps/rumybyways/pages_current.xml
[edit] Compressed XML dumps.
I think compressed versions of database dumps should also be available. It will save users' and system's bandwidth for aboud 5 times. Such files are very compressable:
-rw-r--r-- 1 vi vi 21372701 2008-01-12 12:49 absurdopedia/pages_current.xml -rw-r--r-- 1 vi vi 6032260 2008-01-13 16:10 absurdopedia/pages_current.xml.gz -rw-r--r-- 1 vi vi 3939597 2008-01-13 16:10 absurdopedia/pages_current.xml.bz2 -rw-r--r-- 1 vi vi 3915674 2008-01-13 16:09 absurdopedia/pages_current.xml.7z -rw-r--r-- 1 vi vi 3728693 2008-01-13 16:48 absurdopedia/pages_current.xml.PPMd.7z -rw-r--r-- 1 vi vi 2900586 2008-01-13 16:22 absurdopedia/pages_current.xml.paq8l
I think 7-Zip with PPMd option will be optimal algorithm (it is designed for text data).
Wikipedia already provides compressed dumps of their databases. _Vi 14:56, 13 January 2008 (UTC)
Some of the Uncyclopedias are hosted on external co-lo servers and are archived as .zip; even that (instead of the more-aggressive bzip2 or 7zip) is compressing the text (with revision history) about 9 times, not five. Without .zip, an uncompressed Desciclopédia here would run about three and a half gigabytes instead of only a semi-unwieldy few hundreds of megabytes:
unzip -v pt-wiki.zip Length Method Size Ratio Date Time CRC-32 Name -------- ------ ------- ----- ---- ---- ------ ---- 3766776108 Defl:N 326250194 91% 02-05-08 01:26 ee981595 pt-pages_full.xml -------- ------- --- ------- 3766776108 326250194 91% 1 file
[edit] Restoring images in a copied Wikia?
I have the Doom Wiki copied locally for my own personal uses (when I'm offline), but I was wondering, how do I get the images to load? I try `tar xf images.tar` when in the mediawiki directory (MediaWiki 1.11.1 to be precise), but the wiki itself doesn't use any of the images, and still claims that no files have been uploaded :/ --67.183.244.133 03:11, 1 February 2008 (UTC)
A couple of options:
- php maintenance/importImages.php path/to/images/here jpg gif png svg ico ogg mp3
or:
- php maintenance/rebuildImages.php --missing
The first imports a set of images from some arbitrarily-specified directory and puts them in the wiki, the second presumes the images are already in their proper place on the disc and just need to be listed in the database. Each uses one of the various command-line maintenance scripts included with MediaWiki. Both seem to create many useless log entries as "maintenance script" or "image import script", but they do provide the functionality you're looking for. --carlb 19:58, 5 February 2008 (UTC)
[edit] wikistats being moved
According to info from User:KyleH over IRC, wikistats is currently being migrated to a new server and will be mostly unavailable during this time. He did not have an ETA for when the new server would be online. —Dr Ishmael 03:03, 14 June 2008 (UTC)