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'
ResolutionCheck /var/log/mysqld.log for possible errors.
Increase wait_timeout in /etc/my.cnf:
Restart MySQL and try to restore backup again.