Alright so this is my problem. My site (
)
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