The Community Forums

Interact with an entire community of cPanel & WHM users!
  1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

MySQL:Lost connection to server during query

Discussion in 'Database Discussions' started by kavos1332, Oct 9, 2013.

  1. kavos1332

    kavos1332 Active Member

    Dec 17, 2012
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator

    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.
  2. cPanelMichael

    cPanelMichael Forums Analyst
    Staff Member

    Apr 11, 2011
    Likes Received:
    Trophy Points:
    cPanel Access Level:
    Root Administrator
    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.

Share This Page