MySQL found corrupt tables

[Qrup]

Hi All,

What do I do with this problem:

db_ispconfig.isp_traffic
warning : 1 client is using or hasn't closed the table properly

Improperly closed tables are also reported if clients are accessing
the tables *now*. A list of current connections is below.

+----+------------------+-----------+----+---------+------+-------+------------------+
| Id | User | Host | db | Command | Time | State | Info |
+----+------------------+-----------+----+---------+------+-------+------------------+
| 5 | debian-sys-maint | localhost | | Query | 0 | | show processlist |
+----+------------------+-----------+----+---------+------+-------+------------------+
Uptime: 1 Threads: 1 Questions: 81 Slow queries: 0 Opens: 78 Flush tables: 1 Open tables: 64 Queries per second avg: 81.000

I'm not the big SQL shark, so I hope you guys can help me.

/Qrup

[rayit]

maybe restart mysql, after that it repairs tables

helped for me sometimes..

[marclar]

You have diffrent aproaches for repairing tables in mysql..
take a look at this link:

click here (http://dev.mysql.com/doc/refman/5.0/en/repair.html)

i hope it helps ;)

[till]

You can try to repair the database by using the repair database function in ISPConfig under Management ISPConfig Database > Repair Database.