Steve Ruby wrote:
> 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
Hello Steve!
First, thank you very much for your help. I tried to run the myisamchk, the
tables looks good
and the result is e. g.:
# myisamchk -r TurosHat.MYI
Checking MyISAM file: CikktorzsTaki.MYI
Data records: 17 Deleted blocks: 0
- check file-size
- check key delete-chain
- check record delete-chain
- check index reference
- check records and index references
After running the myisamchk, I tried to check and repair the table:
mysql> check table CikktorzsTaki;
ERROR 1064: You have anmysql> check table CikktorzsTaki;
mysql> repair table CikktorzsTaki;
ERROR 1064: You have an error in your SQL syntax near 'check table CikktorzsTaki'
at line 1
Have you got any idea ?
Attila
---------------------------------------------------------------------
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
