migrate to new server error mysql

2 posts / 0 new
Last post
#1 Fri, 01/20/2017 - 00:10
ale.ab

migrate to new server error mysql

Hi, i try to migrate my old vps (centos 6) to new vps (centos 7), but i can do this...

i follow the instruction on https://www.virtualmin.com/documentation/system/migrate

but when i restore on new vps with command virtualmin restore-domain --source /root/backups/ --all-domains --all-features

i receive this error Re-loading MySQL database aaaaaa .. .. load failed! ERROR 1064 (42000) at line 1: You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'mysqldump: Couldn't execute 'SHOW FUNCTION STATUS WHERE Db = 'aaaaaaa'': Cannot l' at line 1

but on my old vps there is MySQL version 5.5.49 on new vps MySQL version 5.5.52 see that on webmin -> servers -> MySQL Database Server

i try also --continue-on-error i see all virtual server but all database is empty...

how cloud i resolve?

thank you in advance

Alessandro

Sun, 01/22/2017 - 02:58
ale.ab

i fixed, there was an mysql error on old server. i run upgrade of mysql and now run correctly.

thank you

Topic locked