Thanks. I've gotten very good at repairing the tables over the past couple of days :-/, but I'd still like to understand the root cause, and especially if there are more mediawiki-specific tools to try to recover / export the data if I need it. My last time recovering, it looked like myisamchk deleted some records from the data file, though I'm not sure if it does that, or just touches the .MYIs.
I enabled the debug log, and all I see that's suspicious is frequent abrupt exits from RawPage::view, line 59 of includes/RawPage.php. From looking at the code, it looks like perhaps that line of code shouldn't be in that function??
I'm running mediawiki version 1.3.1, btw.
thanks, -Nick
Brion Vibber wrote:
Nick Triantos wrote:
I just installed mediawiki a week ago. I love the product, but something seems to be very wrong with the sql databases on which the wiki is driven. I've gotten corruption about 5 times already. Now, when I browse to the wiki server, Firefox doesn't even return an empty page, it looks like php is hanging or crashing (not sure which).
Is there any way to somewhat manually recover data from the databases? Is there any way to meaningfully export and re-import the data?
Start here: http://dev.mysql.com/doc/mysql/en/Repair.html
-- brion vibber (brion @ pobox.com)
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l