After running mwdumper downloaded from wikimedia.org and dated 1 feb 06 with either of the following commands:
java -jar mwdumper.jar --format=mysql:1.5 /wikidump/dump/enwiki-20070206-pages.articles.xml | mysql --default-chracter-set=utf8 -u root -p chrpdb
java -jar mwdumper.jar --format=mysql:1.5 /wikidump/dump/enwiki-20070206-pages.articles.xml | mysql -u root -p chrpdb
no pages show up in any of the edit histories for the wiki at all with the new wiki. In other words, it does not appear to work. This has also been reported on several other blogs and wikis.
WIKI CONFIG:
This wiki is powered by *MediaWiki http://www.mediawiki.org/*, copyright (C) 2001-2006 Magnus Manske, Brion Vibber, Lee Daniel Crocker, Tim Starling, Erik Möller, Gabriel Wicke, Ævar Arnfjörð Bjarmason, Niklas Laxström, Domas Mituzas, Rob Church and others.
MediaWiki is free software; you can redistribute it and/or modify it under the terms of the GNU General Public License as published by the Free Software Foundation; either version 2 of the License, or (at your option) any later version.
MediaWiki is distributed in the hope that it will be useful, but WITHOUT ANY WARRANTY; without even the implied warranty of MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the GNU General Public License for more details.
You should have received a copy of the GNU General Public License http://chrp.wikigadugi.org/COPYING along with this program; if not, write to the Free Software Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA. or read it online http://www.gnu.org/copyleft/gpl.html
* MediaWiki http://www.mediawiki.org/: 1.8.2 * PHP http://www.php.net/: 5.1.4 (apache2handler) * MySQL http://www.mysql.com/: 5.0.18 * Extensions: o Parser hooks: + /Cite/ http://meta.wikimedia.org/wiki/Cite/Cite.php, adds <ref[ name=id]> and <references/> tags, for citations, by Ævar Arnfjörð Bjarmason + /ParserFunctions/ http://meta.wikimedia.org/wiki/ParserFunctions by Tim Starling o Extension functions: + wfSetupParserFunctions and wfCite o Parser extension tags: + <ref>, <references> and <pre> o Parser function hooks: + expr, if, ifeq, ifexpr, switch, ifexist, int, ns, urlencode, lcfirst, ucfirst, lc, uc, localurl, localurle, fullurl, fullurle, formatnum, grammar, plural, numberofpages, numberofusers, numberofarticles, numberoffiles, numberofadmins, language, padleft, padright and anchorencode * Hooks: o LanguageGetMagic: wfParserFunctionsLanguageGetMagic o ParserClearState: (Cite, clearState)
Jeff
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Jeffrey V. Merkey wrote:
MySQL http://www.mysql.com/: 5.0.18
MySQL 5.0.18 is only experimentally supported by MediaWiki, the production sites use MySQL 4.0.
Catch 22. Now I think we are getting to the bottom of the problems. Modern Linux Distros which support php 5.1 are NOT on mysql 4.X at all. These tools are designed for OS systems which no longer exist.
Jeff
Edward Z. Yang wrote:
-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1
Jeffrey V. Merkey wrote:
MySQL http://www.mysql.com/: 5.0.18
MySQL 5.0.18 is only experimentally supported by MediaWiki, the production sites use MySQL 4.0. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.6 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iD8DBQFF4lsfqTO+fYacSNoRAgvXAKCI8Wzsm8SlzVn/5+XqgolBl788ZQCdEkeM 36DwjxHlLPRJOl8sTaO0rCg= =WjIn -----END PGP SIGNATURE-----
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l
On 26/02/07, Edward Z. Yang edwardzyang@thewritingpot.com wrote:
MySQL 5.0.18 is only experimentally supported by MediaWiki, the production sites use MySQL 4.0.
MediaWiki works with MySQL 5.x without problems if you use the latin1 schema. I don't think this is the actual cause.
Jeff, are you saying that the page histories appear to be blank when accessed? If so, this *could* be a caching problem if the page_touched columns haven't been updated.
Could you run a quick statement such as UPDATE page SET page_touched = 20070226080700 and see if that cures the problem? Please also do a hard-reload when viewing one of these pages.
If I've interpreted what the problem is wrongly, then please clarify.
Thanks,
Rob Church
Rob Church wrote:
On 26/02/07, Edward Z. Yang edwardzyang@thewritingpot.com wrote:
MySQL 5.0.18 is only experimentally supported by MediaWiki, the production sites use MySQL 4.0.
MediaWiki works with MySQL 5.x without problems if you use the latin1 schema. I don't think this is the actual cause.
Jeff, are you saying that the page histories appear to be blank when accessed? If so, this *could* be a caching problem if the page_touched columns haven't been updated.
Could you run a quick statement such as UPDATE page SET page_touched = 20070226080700 and see if that cures the problem? Please also do a hard-reload when viewing one of these pages.
If I've interpreted what the problem is wrongly, then please clarify.
Thanks,
Rob Church
Rob,
I think you have it. I am running importDump.php across three wikis tonight, so I'll have to retest tommorrow. I needed to get the wikis back up, so after it barfed, I just purged out the databases and started importDump on clean db files. I can also do this one tommorrow and try out these commands.
Jeff
Wikitech-l mailing list Wikitech-l@lists.wikimedia.org http://lists.wikimedia.org/mailman/listinfo/wikitech-l
wikitech-l@lists.wikimedia.org