[PLUG] Mysql db recovery problems

[Rogan Creswick]

On Thu, Feb 21, 2008 at 11:07 AM, Wil Cooley <wcooley at nakedape.cc> wrote:
>
>  Have you checked the permissions on database files? Are they and the
>  directory they are writable by the user mysqld runs as?

The permissions are Ok -- they are the same as other databases that
were not corrupted, and those DBs are working just fine.   (The
directory has permissions: drwx------ mysql:mysql and all the files
are -rw-rw---- mysql:mysql)

> Did you try using myisamchk in recovery mode anyway? Maybe with '--safe-recover'?
>

I just did this, and then realized that the MYI files seemed to be ok
(only three tables are in MYIs? I don't know the difference between a
MYI, MYD and frm)  Most of the tables seem to be stored in .frm's,
which myisamchk won't do anything with:

 $ myisamchk --safe-recover user.frm
myisamchk: error: 'user.frm' is not a MyISAM-table

I am able to read the content of the MYI tables (the search index),
for what that's worth.  (I can extract quite a bit of the content from
there if that's all I can get.)

--Rogan