Show tables causing disconnect
| User, date | Message |
|---|---|
|
Written by upl8t
10 months 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
10 months ago 4018 posts since Fri, 07 Apr 06 |
Try out mysql.exe and run SHOW TABLE STATUS. |
|
Written by upl8t
10 months 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
10 months ago 4018 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
10 months 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. |