I've been running mediawiki at sauwiki.com (a site for my school) for a couple of years now. I upgraded a couple of months ago to the latest version, and it has been working fine until last week, when it greeted me with the database error you can see there now:
A database error has occurred Query: SELECT ug_group FROM `user_groups` WHERE ug_user = '1' Function: User::loadFromDatabase Error: 1017 Can't find file: 'user_groups.MYI' (errno: 2) (localhost)
Backtrace:
* GlobalFunctions.php line 451 calls wfbacktrace() * Database.php line 408 calls wfdebugdiebacktrace() * Database.php line 358 calls databasemysql::reportqueryerror() * Database.php line 734 calls databasemysql::query() * User.php line 692 calls databasemysql::select() * User.php line 622 calls user::loadfromdatabase() * Setup.php line 209 calls user::loadfromsession() * index.php line 63 calls require_once()
I tried to run check tables on it, but it didn't seem to have any effect.
I found this person: http://mail.wikipedia.org/pipermail/mediawiki-l/2005-September/007350.html who had the same problem, and the suggestion was to ask the host about fixing the database, but when I contacted iPowerweb they told me their databases were working fine, and that they didn't support third party software.
When I use phpmyadmin I get a similar error when trying to browse the "users_groups" table, but the other tables are still there.
So what I am asking, is how can I restore my wiki without losing the data?
Thank you,
Brian