Your "page" table is buggered. This will be a messier process than you'd hoped for.
Rob Church
On 22/12/05, mediawiki@x11.cjb.net mediawiki@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@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@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
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l
MediaWiki-l mailing list MediaWiki-l@Wikimedia.org http://mail.wikipedia.org/mailman/listinfo/mediawiki-l