I'm not sure I will be able to fix the databases on iPowerWeb, I am now trying things on my on Linux box.
I was able to export the database into a really long sql statement, but it appeared to inly get the first five tables, among them 'cur' and 'archive'.
I see that the latest version of mediawiki (1.5.2) uses 'text' instead of 'cur', so it won't restore. For some reason I am having trouble installing older versions.
If I open the sql file in a text editor (its about 1 meg), I can see that all the content from my wiki is still there. So I ask, what is the best way to attempt restoring it?
Thanks,
Brian
On Tuesday 20 December 2005 12:56 pm, Jan Steinman wrote:
From: mediawiki@x11.cjb.net
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)
It would appear that the index file for the user_groups table has been deleted or has wrong permissions.
I tried to run check tables on it, but it didn't seem to have any effect.
If you run myisamchk from a shell prompt, it should tell you it can't access the table.
I found this person... 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.
Tell them you're not using third-party software; tell them you have a database table called "user_groups" that has a problem. Don't mention MediaWiki at all -- it's an MySQL problem!
If you're lucky, they can fix that file's permissions. If you're slightly less lucky, they may restore it from a recent backup. There may be a way of re-creating it if the corresponding .MYD and .FRM files are intact.
If the file is simply gone, consider some other service provider!
:::: There was a time when religion ruled the world. It is known as
The Dark Ages. -- Ruth Hurmence Green
:::: Jan Steinman http://www.Bytesmiths.com/Van
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l