Migration of cpanel (mysql8 to mysql8) backup to virtualmin

I am migrating my dedicated server from whm/cpanel to virtualmin.
After seeing that Grant and User Creation must be in seperate lines in mysql8, I upgraded my mysql5.7 cpanel to mysql8.0 and then I took a backup, thinking that it would properly export a backup with 2 seperate lines; but it exported the same sql lines which cannot be imported into virtualmin, which is Cpanel’s problem not Virtualmin’s. I think they are handling restoration on the air and manipulating those user creation and priviledge grants on the air while restoring, otherwise they also have to have problems…

So, I am trying to find out if there is a better way than manually modifying all the backup files from cpanel per account (specifically mysql.sql file which includes incompatible user/grant lines).

“Re-creating MySQL users …
Failed to migrate virtual server : SQL grant all on mydb\_wp.* to ‘mydb_wp’@‘localhost’ with grant option failed : You are not allowed to create a user with GRANT”

OS type and version Ubuntu 20.04
Virtualmin version 6.17

This topic was automatically closed 60 days after the last reply. New replies are no longer allowed.