• Introducing WebPros Cloud - a fully managed infrastructure platform purpose-built to simplify the deployment of WebPros products !  WebPros Cloud enables you to easily deliver WebPros solutions — without the complexity of managing the infrastructure.
    Join the pilot program today!
  • The Horde component is removed from Plesk Installer. We recommend switching to another webmail software supported in Plesk.
  • The BIND DNS server has already been deprecated and removed from Plesk for Windows.
    If a Plesk for Windows server is still using BIND, the upgrade to Plesk Obsidian 18.0.70 will be unavailable until the administrator switches the DNS server to Microsoft DNS. We strongly recommend transitioning to Microsoft DNS within the next 6 weeks, before the Plesk 18.0.70 release.

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