Hello DB-users,admins, I have serious problem with a table in a DB that I have. This is on a mysql-4.0.20.
mysql> CHECK TABLE Users; +--------------+-------+----------+----------------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+-------+----------+----------------------------------------------+ | atmail.Users | check | warning | Table is marked as crashed | | atmail.Users | check | warning | Size of indexfile is: 23552 Should be: 1024 | | atmail.Users | check | warning | Size of datafile is: 81368 Should be: 0 | | atmail.Users | check | error | Found wrong record at 0 | | atmail.Users | check | error | Corrupt | +--------------+-------+----------+----------------------------------------------+ 5 rows in set (0.39 sec) Initially ... beastie# ls -al Users.* -rwxr-x--- 1 mysql mysql 81368 Aug 4 11:33 Users.MYD -rwxr-x--- 1 mysql mysql 23552 Aug 4 14:29 Users.MYI -rwxr-x--- 1 mysql mysql 9404 Aug 4 11:33 Users.frm I have read the manuals about myisamchk (-e, -r, -o) and REPAIR TABLE table_name USE_FRM but in both cases when I perform the repair, the Users.MYI is then reset to a value of 0. After I run repair .... mysql> REPAIR TABLE Users USE_FRM; +--------------+--------+----------+----------------------------------------+ | Table | Op | Msg_type | Msg_text | +--------------+--------+----------+----------------------------------------+ | atmail.Users | repair | info | Key 1 - Found wrong stored record at 0 | | atmail.Users | repair | status | OK | +--------------+--------+----------+----------------------------------------+ 2 rows in set (0.05 sec) beastie# ls -al Users.* -rwxr-x--- 1 mysql mysql 0 Aug 4 14:36 Users.MYD -rwxr-x--- 1 mysql mysql 1024 Aug 4 14:36 Users.MYI -rwxr-x--- 1 mysql mysql 9404 Aug 4 11:33 Users.frm Now for sure there is no data at all in the table. mysql> select * from Users; Empty set (0.01 sec) Is there hope for me in this situation??? I have googled and googled but all that I see doesn't seem to help me to recover the data in the table. This makes me very desparate. I'd be very thankful for any pointers that would help me out of this successfully. I have backup copies of those files. -Wash http://www.netmeister.org/news/learn2quote.html -- +======================================================================+ |\ _,,,---,,_ | Odhiambo Washington <[EMAIL PROTECTED]> Zzz /,`.-'`' -. ;-;;,_ | Wananchi Online Ltd. www.wananchi.com |,4- ) )-,_. ,\ ( `'-'| Tel: +254 20 313985-9 +254 20 313922 '---''(_/--' `-'\_) | GSM: +254 722 743223 +254 733 744121 +======================================================================+ The fact that boys are allowed to exist at all is evidence of a remarkable Christian forbearance among men. -- Ambrose Bierce -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]