Page MenuHomePhabricator

Database tables corrupt beyond repair
Closed, InvalidPublic

Description

Author: kym

Description:
I noticed that two of my tables inside my wikipedia install had the "in use" tag on them in phpMyAdmin - a quick search tells me that this is due to corrupt data and this could have been the reason for me being unable to upgrade mediawiki as the upgrade process always stopped at the following tables.

The two following tables are corrupt beyond repair:

pinkptc_neodex.neodex_cur
Error : Incorrect key file for table 'neodex_cur'; try to repair it
error : Corrupt

pinkptc_neodex.neodex_oldimage
Error : Incorrect key file for table 'neodex_oldimage'; try to repair it
error : Corrupt

I tried to run repair on these tables via numerous methods but all were unsuccessful. I asked my host for help and they ran into the same issues. Their suggestion was: Basically you would need to either create those from scratch.

What are my options?


Version: unspecified
Severity: major

Details

Reference
bz23661

Event Timeline

bzimport raised the priority of this task from to Medium.Nov 21 2014, 11:11 PM
bzimport set Reference to bz23661.
bzimport added a subscriber: Unknown Object (MLST).

Like bug 23614 you also filed, this is an issue on your end that you will need to sort out, Bugzilla is not a support forum for larger issues with your server.

I agree with your host that creating the tables from scratch is probably the best course of action at this point. Completely new tables with a fresh copy of the latest stable MediaWiki is my suggestion.

Again: this is not a bug in MediaWiki, so please do not seek further support on your mySQL issues here.