Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > ISPConfig 2 > General

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Thread Tools Display Modes
Old 17th June 2006, 17:45
Qrup Qrup is offline
Join Date: Feb 2006
Posts: 39
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL found corrupt tables

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.

Reply With Quote
Sponsored Links
Old 18th June 2006, 01:07
rayit rayit is offline
Join Date: Nov 2005
Posts: 93
Thanks: 0
Thanked 2 Times in 2 Posts
Default give it a try?

maybe restart mysql, after that it repairs tables

helped for me sometimes..
Reply With Quote
Old 18th June 2006, 10:09
marclar marclar is offline
Join Date: Jun 2006
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to marclar

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

click here

i hope it helps
Reply With Quote
Old 18th June 2006, 20:41
till till is offline
Super Moderator
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 37,015
Thanks: 840
Thanked 5,652 Times in 4,461 Posts

You can try to repair the database by using the repair database function in ISPConfig under Management ISPConfig Database > Repair Database.
Till Brehm
Get ISPConfig support and the ISPConfig 3 manual from ispconfig.org.
Reply With Quote


Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Having Problems with KWiFiManager sbovisjb1 Installation/Configuration 7 17th April 2006 23:53
ISPC install stops str2etboy Installation/Configuration 19 28th January 2006 08:18
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 17:04
MySQL issue during install of ISPConfig ricbax Installation/Configuration 4 16th September 2005 10:41
mysqlcheck has found corrupt tables m u r Installation/Configuration 1 18th August 2005 11:47

All times are GMT +2. The time now is 02:48.

Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.