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

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
Reply
 
Thread Tools Display Modes
  #1  
Old 17th June 2006, 17:45
Qrup Qrup is offline
Member
 
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:

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
Reply With Quote
Sponsored Links
  #2  
Old 18th June 2006, 01:07
rayit rayit is offline
Member
 
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
  #3  
Old 18th June 2006, 10:09
marclar marclar is offline
Member
 
Join Date: Jun 2006
Posts: 40
Thanks: 0
Thanked 0 Times in 0 Posts
Send a message via MSN to marclar
Default

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

click here

i hope it helps
__________________
www.emanuel.si
Reply With Quote
  #4  
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
 
Default

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
Reply

Bookmarks

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.