Show tables causing disconnect

upl8t posted 3 years ago in General
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

/* 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.
ansgar posted 3 years ago
Try out mysql.exe and run SHOW TABLE STATUS.
upl8t posted 3 years ago

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
ansgar posted 3 years ago
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.
upl8t posted 2 years ago
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.