MySQL:Lost connection to server during query

kavos1332

Active Member
Dec 17, 2012
40
0
6
cPanel Access Level
Root Administrator
Hi.

Recently some has been corrupted. We repaired them now we have a strange issue. Every single query we run through MySQL console raises "Lost connection" however some queries like create database do work. When we want to restore a db from backup, it creates a few tables and complains about connection loose. So, Some dbs which have corrupted tables neither can be dropped nor restored correctly from backup. For driooung, I do it manually by deleting its directory (after stopping mysql) and removing it from mysql database. Aloso some scripts which have innodb tables sometimes do work and some other times say L"ost Connection" when refresh.

I have already tried innodb_force_recovery, timeout settings but chance.

Please advise.
Thanks in advance.
 

cPanelMichael

Administrator
Staff member
Apr 11, 2011
47,913
2,201
363
Hello :)

Do you have any custom entries in your /etc/my.cnf file that could be dropping the MySQL connections? Also, do you notice any specific error messages in your MySQL error log (/var/lib/mysql/$hostname.err)?

Thank you.