Last modified: 2014-09-06 01:54:39 UTC
Please import the missing wikis from this list: https://wikiteam.googlecode.com/svn/trunk/listsofwikis/mediawikis_2013_checked.txt note that it has some overlap with Pavlo's list in the same directory, which was already imported previously.
fwiw, arbitrary string "See the schedule at [[Wikimedia Foundation Annual Plan]]." in there hmm.. some are ending in index.php, not api.php, i would like one type only, the api.php ones..
total number in list: 13220 ending in api.php: 10268 reduced list to SQL: for wiki in $(cat mediawikis_2013_checked_api.txt); do echo "INSERT IGNORE INTO mediawikis (statsurl,method) VALUES (\"$wiki\",\"8\");"; done > mediawikis_2013_checked_api.sql mysql wikistats < mediawikis_2013_checked_api.sql duplicates are skipped, results in new wikis without names in the table: 8997 importing new wikis, get names and stats from APIs: sudo -u wikistatsuser /usr/bin/php /usr/lib/wikistats/update.php mw import (which is a special import run that also sets the name) minimal fix to the import itself: https://gerrit.wikimedia.org/r/#/c/157322/ now running ... A(126/8992)
Wow! Great.
and after it was finished running it said: 6188 wikis succesfully imported.