MySQL:Lost connection to server during query

kavos1332

• October 09, 2013 05:56

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

  • October 14, 2013 17:08

  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.

  0

Please sign in to leave a comment.