Our wiki failed suddenly two days ago with a complaint that it can't find user_groups.MYI:
Query: SELECT ug_group FROM `user_groups` WHERE ug_user = '3' Function: User::loadFromDatabase Error: 1017 Can't find file: 'user_groups.MYI' (errno: 2) (localhost)
Also I can no longer look at the dbase in phpMyAdmin because "page.MYI" is not found.
The thing is, looking at a backup of the dbase when things were working fine, there was no user_groups.MYI or page.MYI then either. There are a bunch of 'tables' that have only .frm files: page, pagelinks, revision, validate, user_groups. I honestly have no idea what a .frm file does by itself. Are these obsolete files leftover from upgrades? But then, why is the code looking for them?
My ISP has no idea what to do, apparently. Does anyone have any hints? I have a backup of the dbase but I'm not sure what to do or what to tell the ISP to do. This is 2 years of work and we're freaking :(
Install info: MW 1.5.8 MySQL 4.0.18 Apache/Linux hosting (iPower)
Thanks so much, Michelle