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:

    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.

  2. rayit

    rayit New 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