Virtualmin Restore Domain: error while Re-creating mail and FTP users

[gscerb]

Operating system: Ubuntu
OS version: 20.04
Webmin: 1.973
Virtualmin 6.15

I ran > virtualmin restore-domain --source /mydomain.com.tar.gz --domain mydomain.com --all-features

I received this error:

Re-creating mail and FTP users …

Error: SQL grant all on johns\_login.* to ‘johns_johns’@’%’ with grant option failed : You are not allowed to create a user with GRANT

[gscerb]

Solved.

The source backup file was created on a Mariadb server and the recipient server was running Mysql.

Once I deleted Mysql on the recipient server and installed Mariadb the backup restoration was successful.