transfer problem from hostgator cpanel to plesk vps

[derkrieger]

hello

i want transfer the database from hosgator cpanl to plesk vps server
but i got this error : Unable to import the admin_test dump:

ERROR 1115 (42000) at line 41: Unknown character set: 'utf8mb4'
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 100, in main
restore(options, password)
File "/usr/local/psa/lib/modules/python/dbbackup/dbbackup.py", line 89, 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

also this is the phpmyadmin infos on hostgator : https://www.diigo.com/item/image/5kxea/8x0n
and this from plesk : https://www.diigo.com/item/image/5kxea/j0ir
how can i solve this please ? den i have tried to import many databases but the same error

2- i have tried to move some files using filezilla but the size was to big also i wanted complete the transfer today but i has the error : Append/Restart not permitted, try again
Error: File transfer failed
how can i activate the Append option please ?

thanks
amine

 

[Alvin_Allen]

Hi, for the database, it looks like the problem is your version of MySQL on your Plesk (5.1.73). The character set 'utf8mb4' was not supported until MySQL 5.5.

 

[derkrieger]

ok and how can i solve this please ?

 

[IgorG]

Just upgrade MySQL on Plesk to 5.5 version - https://kb.plesk.com/en/125589