cannot import database dump after moving to a new server

[Stavros]

TITLE:

cannot import database dump after moving to a new server​

PRODUCT, VERSION, OPERATING SYSTEM, ARCHITECTURE:

plesk onyx 17, centos 7.4 64bit, MYSQL​

PROBLEM DESCRIPTION:

Hello, I upgraded from centos 6.9 to centos 7.4 and I have problem with the transfer of 2 databases. The one is 46MB and the other 450MB. I tried to increase the max allowed packet with no result.

The error I get in sqldump is this for the small file:
ERROR 2006 (HY000) at line 396: MySQL server has gone away
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module>
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main
restore(options, password)
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
Exception: program 'mysql' finished with non-zero exit code: 1

And this for the large file:

Unable to import the northmet_vbf316 dump:

ERROR 2006 (HY000) at line 1717: MySQL server has gone away
Traceback (most recent call last):
File "/usr/local/psa/admin/sbin/dbbackup", line 6, in <module>
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 99, in main
restore(options, password)
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 88, in restore
raise Exception("program 'mysql' finished with non-zero exit code: %d" % p.returncode)
Exception: program 'mysql' finished with non-zero exit code: 1

p.s. mysql on centos 6.9 was 5.1.73 and now on centos 7.4 is the new 5.5.56-MariaDB version.


Are there any ideas/suggestions?​

STEPS TO REPRODUCE:

.​

ACTUAL RESULT:

.​

EXPECTED RESULT:

.​

ANY ADDITIONAL INFORMATION:

​

YOUR EXPECTATIONS FROM PLESK SERVICE TEAM:

Help with sorting out​

 

[IgorG]

Hello, I upgraded from centos 6.9 to centos 7.4

Just for clarification - did you do this update on the server where your Plesk was installed?
Note, that Plesk support only Debian/Ubuntu distupgrade, not CentOS - Dist-Upgrade Support

 

[Stavros]

Hi. Actually, we just migrate to a new server with this operating system. The databases worked well on the previous one.

 

[IgorG]

MySQL server has gone away

Timeout defined in the my.cnf was exceeded. Increase the wait_timeout value in the MySQL server configuration file/etc/my.cnf

 

[Tracey Wood]

I am assuming you are using on windows or Linux Consol
Run Command Prompt Using Administor
Prompt for password
mysql -u <username> -p <your database name> < <your filename.sql>

Enter password directly

mysql -u <username> -p<PlainPassword> <your database name> < <your filename.sql>