• If you are still using CentOS 7.9, it's time to convert to Alma 8 with the free centos2alma tool by Plesk or Plesk Migrator. Please let us know your experiences or concerns in this thread:
    CentOS2Alma discussion

cannot import database dump after moving to a new server

Stavros

New Pleskian
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
 
Hi. Actually, we just migrate to a new server with this operating system. The databases worked well on the previous one.
 
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>
 
Back
Top