Jeffrey Vernon Merkey wrote:
NOTE: Many of these errors are self-referencing
#REDIRECT statements
which cause database corruption if not applied in the right order.
Offhand I'd guess that your table schemas are wrong, using
case-insensitive collation. Page title fields must be set as binary
(varbinary or varchar binary) to ensure you don't get duplicate key
errors.
Can you double-check?
Table Schema's are those produced by tables.sql. I use the following
script (passwords removed) to create the shell database. Opening the XML
dump with hexedit reveals there are in fact a large number of duplicate
titles.
I am guessing this may be due to the clustering setup you are using not
checking for duplicate titles. <title>Ohm Law</title> is one example to
check.
Here is the method I use for each MediaWiki version to setup the base tables.
mysqladmin drop endb --password=XXXX
mysqladmin create endb --password=XXXX
echo "grant all privileges on endb.* to wgchr@localhost identified by
'dhbowt';" | mysql --password=XXXX
echo "flush privileges" | mysql --password=XXXX
mysql --password=XXXX endb < /wikidump/en/maintenance/tables.sql
mysql --password=XXXX endb < /wikidump/en/maintenance/wikipedia-interwiki.sql
php maintenance/createBcrat.php WikiSysop XXXX
php maintenance/changePassword.php --user=WikiSysop --password=XXXX
Jeff
-- brion vibber (brion @
wikimedia.org)
_______________________________________________
Wikitech-l mailing list
Wikitech-l(a)lists.wikimedia.org
http://lists.wikimedia.org/mailman/listinfo/wikitech-l