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
In phpMyAdmin, did you try to : - select all tables - repair them - optimize them
2006/5/11, Michelle michelle.sg1@gmail.com:
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
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
phpMyAdmin won't even complete loading its page to show those options, because it thinks page.MYI is missing...
On May 10, 2006, at 9:52 PM, iubito wrote:
In phpMyAdmin, did you try to :
- select all tables
- repair them
- optimize them
Michelle wrote:
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?
Sounds like your ISP disabled InnoDB support, probably accidentally during an upgrade. Tell them to turn it back on.
-- brion vibber (brion @ pobox.com)
On May 11, 2006, at 1:42 PM, Brion Vibber wrote:
Michelle wrote:
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?
Sounds like your ISP disabled InnoDB support, probably accidentally during an upgrade. Tell them to turn it back on.
-- brion vibber (brion @ pobox.com)
Thanks very much, I see that it is disabled and I've asked for it to be re-enabled. But does this mean there is data for the wiki dbase that isn't stored in the regular MySQL table files, so that when I take a backup of the mysql/data directory (via the CPanel), I'm not getting everything?
I want to move hosting, but all I have are the MySQL table files, not the single sql file... does that mean I don't have all I need, and I first need to be able to do an sql export?
Sorry for the dumb questions... Michelle
Michelle wrote:
Thanks very much, I see that it is disabled and I've asked for it to be re-enabled. But does this mean there is data for the wiki dbase that isn't stored in the regular MySQL table files,
Yes. Not all MySQL data are stored in those subdirectories.
so that when I take a backup of the mysql/data directory (via the CPanel), I'm not getting everything?
That's entirely possible. Copying files out of MySQL's data directory is not a reliable backup mechanism, especially if you're only copying from some database's subdirectory.
I want to move hosting, but all I have are the MySQL table files, not the single sql file... does that mean I don't have all I need, and I first need to be able to do an sql export?
Probably.
-- brion vibber (brion @ pobox.com)
Thank you so very much, Brion. Once I told the ISP what they needed to do, 3 or 4 times, they turned InnoDB back on and the wiki came back to life.
And it's very helpful to know that the vDeck database backup mechanism is bascially useless for the wiki.
Thanks again -- a whole bunch of nervous contributors are forever in your debt :)
Michelle
On 5/12/06, Brion Vibber brion@pobox.com wrote:
Michelle wrote:
Thanks very much, I see that InnoDB is disabled and I've asked for it to be re-enabled. But does this mean there is data for the wiki dbase that isn't stored in the regular MySQL table files,
Yes. Not all MySQL data are stored in those subdirectories.
mediawiki-l@lists.wikimedia.org