[Mediawiki-l] Re: "user_groups" database corruption

Fri Dec 23 21:16:19 UTC 2005

Can you point me at a source of info on "repairing all tables" you referred
to in the previous post?  I have lost the small icons to the editing window
edit bar and need to rebuild something, so thought I might try the
rebuilding of tables you're referring to.

I've asked several times about what ties these icons into the application
but nobody has offered any ideas, so I'm ready to try something new. 

-----Original Message-----
From: mediawiki-l-bounces at Wikimedia.org
[mailto:mediawiki-l-bounces at Wikimedia.org] On Behalf Of
mediawiki at x11.cjb.net
Sent: Thursday, December 22, 2005 4:08 PM
To: MediaWiki announcements and site admin list
Subject: Re: [Mediawiki-l] Re: "user_groups" database corruption

Alright so this is my problem.  My site (sauwiki.com)  is down because some
of the tables cannot be read.  I've pretty much lost hope of getting them
back.

I did figure out how to do a repair on all tables, but some of the tables
could not be found.  

Apparently the newer versions of mediawiki do not use the 'cur' table
anymore, but mine still has it because I've been upgrading for about two
years.

I can see all my pages still in this database, how can I get them out, and
put them in a new installation of mediawiki?

-Brian

(this is the list of tables I have, and their problems)

krohnefa_wikidb.archive  	repair  	status  	OK
krohnefa_wikidb.blobs 	repair 	status 	OK
krohnefa_wikidb.brokenlinks 	repair 	status 	O
krohnefa_wikidb.categorylinks 	repair 	status 	OK
krohnefa_wikidb.cur 	repair 	status 	OK
krohnefa_wikidb.hitcounter 	repair 	error 	The handler for the table
doesn't 
support repair
krohnefa_wikidb.image 	repair 	status 	OK
krohnefa_wikidb.imagelinks 	repair 	status 	OK
krohnefa_wikidb.interwiki 	repair 	status 	OK
krohnefa_wikidb.ipblocks 	repair 	status 	OK
krohnefa_wikidb.links 	repair 	status 	OK
krohnefa_wikidb.linkscc 	repair 	status 	OK
krohnefa_wikidb.logging 	repair 	status 	OK
krohnefa_wikidb.math 	repair 	status 	OK
krohnefa_wikidb.objectcache 	repair 	status 	OK
krohnefa_wikidb.oldimage 	repair 	status 	OK
krohnefa_wikidb.page 	repair 	error 	Can't find file: 'page.MYI' (errno:
2)
krohnefa_wikidb.pagelinks 	repair 	error 	Can't find file: 
'pagelinks.MYI' (errno: 2)
krohnefa_wikidb.querycache 	repair 	status 	OK
krohnefa_wikidb.recentchanges 	repair 	status 	OK
krohnefa_wikidb.revision 	repair 	error 	Can't find file: 
'revision.MYI' (errno: 2)
krohnefa_wikidb.searchindex 	repair 	status 	OK
krohnefa_wikidb.site_stats 	repair 	status 	OK
krohnefa_wikidb.text 	repair 	status 	OK
krohnefa_wikidb.trackbacks 	repair 	status 	OK
krohnefa_wikidb.transcache 	repair 	status 	OK
krohnefa_wikidb.user 	repair 	status 	OK
krohnefa_wikidb.user_groups 	repair 	error 	Can't find file: 
'user_groups.MYI' (errno: 2)
krohnefa_wikidb.user_newtalk 	repair 	status 	OK
krohnefa_wikidb.user_rights 	repair 	status 	OK
krohnefa_wikidb.validate 	repair 	error 	Can't find file: 
'validate.MYI' (errno: 2)
krohnefa_wikidb.watchlist 	repair 	status 	OK

On Wednesday 21 December 2005 1:47 pm, mediawiki at x11.cjb.net wrote:
> 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 at 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 at Wikimedia.org
> > http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
>
> _______________________________________________
> MediaWiki-l mailing list
> MediaWiki-l at Wikimedia.org
> http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l at Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l