Product:
Search Type:

'psarestore' utility returns the error "DBD::mysql::st execute failed: MySQL server has gone away" during Plesk backup restore.

Article ID: 3513 
Last Review: Dec,21 2007
APPLIES TO:
  • Plesk 8.x for Linux/Unix

SYMPTOMS

'psarestore' utility shows the following messages during the dump restoration:

DBD::mysql::st execute failed: MySQL server has gone away at
/usr/local/psa/lib/perl5/BU/DB.pm line 54, <FD> line 197174284.
ERROR on exec mysql query  : create database `DB_NAME`
Unable to create mysql database 'DB_NAME'


RESOLUTION

Check /var/log/mysqld.log for possible errors.

Increase wait_timeout in /etc/my.cnf:

wait_timeout 20000

Restart MySQL and try to restore backup again.

Please provide feedback on this article

Did this article help you solve your issue?
Yes
No
Partially
I do not know yet
 
Strongly Agree   Strongly Disagree
  9 8 7 6 5 4 3 2 1
The article is easy to understand
The article is accurate
Additional Comments:
*Please provide us with your email address in case we need to contact you.
*Please type the code you can see.
* - required fields