Please whitelist cPanel in your adblocker so that you’re able to see our version release promotions, thanks!

The Community Forums

Interact with an entire community of cPanel & WHM users!

MySQL:Lost connection to server during query

Discussion in 'Database Discussion' 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 Technical Support Community Manager
    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.
    Stop hovering to collapse... Click to collapse... Hover to expand... Click to expand...

Share This Page

  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Dismiss Notice