On October 19, 2021, we have enabled single-sign-on for our Plesk Support Center to provide a seamless login/account experience. This implies that you’ll be able to use a single account across any of our web-facing properties.
If you had already registered your account at Plesk 360 (formerly known as My Plesk) please use one for login. Otherwise please re-register it using the same email address as your existing Zendesk login (support account). It’s essential that you use the same email address on our support center to ensure that your tickets stay attached to the same account.

Database importing in Plesk fails: ERROR 2006 (HY000): MySQL server has gone away

Follow

Comments

5 comments

  • Avatar
    SergeyK (Edited )

    I'm trying to migrate from Plesk Obsidian Version 18.0.30 Update #2 to the Plesk Obsidian Web Pro Edition

    Version 18.0.30 Update #2

    During the migration I've got a error message "stderr: ERROR 2006 (HY000) at line 724: MySQL server has gone away"

    According to this post  - https://support.plesk.com/hc/en-us/articles/213941425-Database-import-in-Plesk-fails-ERROR-2006-HY000-MySQL-server-has-gone-away I've changed my.cnf file settings - https://prnt.sc/v3w7hf

    I've 1 domain with 600 Mb DB , 2nd domain with the 64Mb DB , and small domain with 12 Mb DB - but error the same - 

    it means that's not a time execution time or memory limit. 

    ========1===========

    stderr: ERROR 2006 (HY000) at line 724: MySQL server has gone away

    ======2===========

    stderr: ERROR 2006 (HY000) at line 693: MySQL server has gone away

    ====3=========

    stderr: ERROR 2006 (HY000) at line 693: MySQL server has gone away

    I asking my hosting support but they can't help me. 

    Do you have any options except of my.cnf file changes and MySQL restart ? 

    0
    Comment actions Permalink
  • Avatar
    SergeyK

    here it is full error result - 

    Failed to copy content of database 'db-name1'
    Migration tools tried to perform operation in 3 attempts: Command execution failed on the local server with non-zero exit code.

    command: mysql --defaults-file=/usr/local/psa/var/modules/panel-migrator/sessions/20201017095432/target-server/my_localhost_db-name1.cnf -h localhost -P 3306 -uadmin db-name1 < /usr/local/psa/var/modules/panel-migrator/sessions/20201017095432/target-server/db-dumps/db-name1.sql
    exit code: 1
    stdout:
    stderr: ERROR 2006 (HY000) at line 1025: MySQL server has gone away

     

    0
    Comment actions Permalink
  • Avatar
    SergeyK

    Source server
    CentOS 6.10 (Final)

    Target Server
    CentOS 7.8.2003 (Core)

    0
    Comment actions Permalink
  • Avatar
    Ivan Postnikov

    Hello SergeyK

    Please, try this article.

    In case it won't help, additional investigation will be required. Use this instruction to contact Plesk Support Directly.

    0
    Comment actions Permalink
  • Avatar
    Muhammad Anees

    Hello,

    I am getting error while installing wordpress on the Domain i bought with hosting.

    Please help to sort out as i have been trying for two days and cannot get wordpress installed.

    Please see attachment for error.

    0
    Comment actions Permalink

Please sign in to leave a comment.

Have more questions? Submit a request