Skip to main content
cPanel Technical Support has been heavily impacted by hurricane Beryl and our ability to respond to tickets has been hindered as a result. We appreciate your understanding and patience as we address these delays.

[case 106345] Problem in restoring the account or transfer tool from other server

Comments

7 comments

  • P00r
    I have the same problem with a very similar configuration, using cloudlinux as well, only not using WAF Comodo rules :) I am trying a manual restore, the transfer looked good but then own cloud started crashing... (the account is an owncloud install mainly)
    0
  • cPanelMichael
    Hello :) Please check to see if /var/lib/mysql/mysql.sock is symbolically linked to /tmp/mysql.sock on the source and destination servers. If not, run this command: ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
    Thank you.
    0
  • chuvadenovembro
    Thanks Michel, On my servers, this was exactly the problem
    0
  • ssavchenko
    Maybe the same problem. The manual backup from: CENTOS 6.5 x86_64 WHM 11.44.0 (build 19) to WHM 11.44.0 (build 18) # readlink -f /tmp/mysql.sock /var/lib/mysql/mysql.sock Error: The system failed to execute "ALTER DATABASE `username_dbname` DEFAULT CHARACTER SET 'utf8'" because of an error: DBD::mysql::db do failed: MySQL server has gone away Failed to remove empty DB "username_dbname": DBD::mysql::db do failed: MySQL server has gone away Saved failed database restore to "/home/username/cpmove_failed_mysql_dbs.1404412357" for maunal restoration. The system failed to reinstall the MySQL database "username_dbname" as "username_dbname" because of an error: The system failed to connect to the MySQL server as "username" because of an error: Unknown database 'username_dbname' at /usr/local/cpanel/Cpanel/DBI.pm line 43.
    Same for the others DB
    0
  • cPanelMichael
    Please open a support ticket if creating the symbolic link does not help. You can post the ticket number here so we can update this thread with the outcome. Thank you.
    0
  • cPanelNick
    [quote="ssavchenko, post: 1679971">Maybe the same problem. The manual backup from: CENTOS 6.5 x86_64 WHM 11.44.0 (build 19) to WHM 11.44.0 (build 18) # readlink -f /tmp/mysql.sock /var/lib/mysql/mysql.sock Error: The system failed to execute "ALTER DATABASE `username_dbname` DEFAULT CHARACTER SET 'utf8'" because of an error: DBD::mysql::db do failed: MySQL server has gone away Failed to remove empty DB "username_dbname": DBD::mysql::db do failed: MySQL server has gone away Saved failed database restore to "/home/username/cpmove_failed_mysql_dbs.1404412357" for maunal restoration. The system failed to reinstall the MySQL database "username_dbname" as "username_dbname" because of an error: The system failed to connect to the MySQL server as "username" because of an error: Unknown database 'username_dbname' at /usr/local/cpanel/Cpanel/DBI.pm line 43.
    Same for the others DB
    Please check your my.cnf to make sure you do not have a very low wait_timeout that is causing mysql connections to be dropped. We have opened case 106345 to handle some of the very low wait_timeouts (the default is 28000s
    0
  • cPanelMichael
    To update, a resolution for internal case number 106345 is included with cPanel version 11.44.0.27: Fixed case 106345: Transfers abort with SIGPIPE if the mysql timeouts are too low. Thank you.
    0

Please sign in to leave a comment.