distal-attribute
distal-attribute
distal-attribute
distal-attribute

Show tables causing disconnect

User, date Message
Written by upl8t
2 years ago
Category: General
4 posts since Tue, 28 Aug 12
I have a problem with 1 database on a server that is hosting dozens of databases.

This database was working fine until a few days ago. It will not display the tables when you select the database. It shows the following error

SHOW TABLE STATUS FROM `mydbname`;
/* SQL Error (2013): Lost connection to MySQL server during query */
/* 0 rows affected, 0 rows found. Duration for 0 of 1 query: 0.000 sec. */

I know for sure that the tables are still there along with the data. The site is still functioning. I can also see the tables using Toad as an alternative tool.

Any ideas on how to solve this? I love using HeidiSQL and would like to keep using it. I appreciate any suggestions.
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
Try out mysql.exe and run SHOW TABLE STATUS.
Written by upl8t
2 years ago
4 posts since Tue, 28 Aug 12

I logged into the server using putty and connected to the mysql server. Here's the result:

show table status;
ERROR 2013 (HY000): Lost connection to MySQL server during query
Written by ansgar
2 years ago
4940 posts since Fri, 07 Apr 06
Well, then this is at least not something in HeidiSQL itself. Probably you have some broken file in "mydbname". You need to talk to someone who has root access to that server.
Written by upl8t
2 years ago
4 posts since Tue, 28 Aug 12
Thanks anse. I have root access to the server. I think I know which file it is although I haven't had any luck repairing it so far.
 

Please login to leave a reply, or register at first.