MySQL found corrupt tables

Discussion in 'General' started by Qrup, Jun 17, 2006.

  1. Qrup

    Qrup New Member

    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
     
  2. rayit

    rayit Member

    give it a try?

    maybe restart mysql, after that it repairs tables

    helped for me sometimes..
     
  3. marclar

    marclar New Member

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

    click here

    i hope it helps ;)
     
  4. till

    till Super Moderator Staff Member ISPConfig Developer

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

Share This Page