Migrating To a New Server, Issues in restoring data

Hello Friends,

I am migrating To a New Server. Both the old and the new server are running CentOS6.

I was following instructions available at https://www.virtualmin.com/documentation/system/migrate

everything went fine until I reached "Restore your domains"

the first command "virtualmin restore-domain --source /home/scaled/backups/virtualmin.tar.gz --all-virtualmin" ran without any errors.

whereas the second command " virtualmin restore-domain --source /home/scaled/backups/ --all-domains --all-features" generates the following error:

sh: file: command not found Failed to read backup file : /home/scaled/backups//thinkersforumpakistan.sql : Not a valid tar or tar.gz file

Can someone help??? Please ...

Status: 
Active

Comments

Make sure that the directory /home/scaled/backups doesn't contain any files other than the Virtualmin tar.gz backup files.

Well... Thank you but now i am stuck with the process halfway ... 10 out of 17 have been restored successfully whereas there was an error which stopped the whole process right after the 9th domain ...

For reference the error is given below:

" Re-loading MySQL database 8solar .. Creating MySQL database 8solar .. .. done

.. load failed! ERROR 1273 (HY000) at line 25: Unknown collation: 'utf8mb4_unicode_ci'

"

Should i start all over again or how can i restart the process from where it has stopped?

Are you perhaps restoring to an older MySQL/MariaDB version?

Was the database upgraded to a different version on the source server?

You may want to check that by running this command on both servers:

mysql -V