Hi, I am running mysql alpha 4.0.2 on solaris 8. I had the following problem:
- I have a table called "call_record" and it has 153501 records. The call_record.MYD file is of size 72,605,973 bytes. I performed myisampack on this table, which brings down the table size to 11,411,888. After myisampack, I also performed myisamchk -rq on the same table. - Then I launched a mysql client session, "CHECK TABLE call_record" told me: mysql> check table call_record; +------------------+-------+----------+---------------------------------------------------------------+ | Table | Op | Msg_type | Msg_text | +------------------+-------+----------+---------------------------------------------------------------+ | yada.call_record | check | warning | Size of datafile is: 72605973 Should be: 11411881 | | yada.call_record | check | error | Found key at page 1024 that points to record outside datafile | | yada.call_record | check | error | Corrupt | +------------------+-------+----------+---------------------------------------------------------------+ 3 rows in set (0.08 sec) I dropped the table and recreated the table, then after performing myisampack and myisamchk, my table is corrupted again. This happened to me 3 times in a row and I wonder if this is a known problem or if I did not do things correctly. Any help would be appreciated, Ning --------------------------------------------------------------------- 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
