Elekes Attila wrote:
>
> Hi!
>
> The mysql server (version 3.22.32-4) has hanged up, and the restarting
> causes a part of the
> *.ISM and *.ISD files are gone. Unfortuanetly, I have not got a backup
> from these files :(
> Is there any method to recover the mysql tables from the remaining
> *.MYD, *MYI and *.frm
> files ? Thanks for ANY help!!!
>
> Attila
First you should backup what you do have left of your files. There just
incase you mess things up worse trying to fix them.
Then, on a copy of the "bad" tables have you tried running
myisamchk -r <tablename>.MYI
or atleast
myisamchk <tablename>.MYI
so you can tell how bad off they are, mysql may simply be able to fix
them itself. See also CHECK TABLE and REPAIR TABLE in the mysql manual
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
