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

Thu Dec 22 23:12:25 UTC 2005

Your "page" table is buggered. This will be a messier process than
you'd hoped for.

Rob Church

On 22/12/05, mediawiki at x11.cjb.net <mediawiki at x11.cjb.net> wrote:
> 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
>