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(a)Wikimedia.org
[mailto:mediawiki-l-bounces@Wikimedia.org] On Behalf Of
mediawiki(a)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(a)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(a)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(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
_______________________________________________
MediaWiki-l mailing list
MediaWiki-l(a)Wikimedia.org
http://mail.wikipedia.org/mailman/listinfo/mediawiki-l