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]

Reply via email to