Hi. It sounds as if you run myisampack/myisamchk while the server was running. This is not supported and has a high probability to corrupt tables (http://www.mysql.com/doc/R/e/Repair.html)
Bye, Benjamin. On Fri, Apr 26, 2002 at 09:50:18PM -0400, [EMAIL PROTECTED] wrote: > 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. [...] > 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 -- [EMAIL PROTECTED] --------------------------------------------------------------------- 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