Hello.
>Apart from this > brightmail.din_top_spam > warning : 1 clients is using or hasn't closed the table properly > status : After what command have you got the warning? CHECK TABLE shouldn't produce it: http://dev.mysql.com/doc/mysql/en/myisamchk-syntax.html "If mysqld is running, you must force it to flush any table modifications that are still buffered in memory by using FLUSH TABLES. You should then ensure that no one is using the tables while you are running myisamchk. The easiest way to avoid this problem is to use CHECK TABLE instead of myisamchk to check tables." Seena Blace <[EMAIL PROTECTED]> wrote: > [-- text/plain, encoding 7bit, charset: us-ascii, 27 lines --] > > Hi, > > Here is what I see. > mysql> check table report_1; > +---------------------------+-------+----------+------------------------------------+ > | Table | Op | Msg_type | Msg_text > | > +---------------------------+-------+----------+------------------------------------+ > | mailtest.report_1 | check | error | record delete-link-chain corrupted | > | mailtest.report_1 | check | error | Corrupt | > +---------------------------+-------+----------+------------------------------------+ > 2 rows in set (0.02 sec) > > Does repair table report_1 command fix? > or anything we need to do extra? > > Apart from this > brightmail.din_top_spam > warning : 1 clients is using or hasn't closed the table properly > status : OK > How to close such kind of table? > thanks > > > > --------------------------------- > Yahoo! Mail Mobile > Take Yahoo! Mail with you! Check email on your mobile phone. -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ ____ __ / |/ /_ __/ __/ __ \/ / Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET <___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
