Hi All!!
I am using Virtualmin 7 webmin 2.0
My VPS was previously used through this Virtualmin and its version is MySQL, recently I plan to switch to a new service provider to administer another VPS, the old service is almost expensive. and that’s where the problem comes from.
When I intentionally create a new VPS and install Virtualmin on the VM, what I get is not the MySQL version, it is transferred to Mariadb and I can’t restore the file I backed up from my old server, help me pls!
I had this one also …
it turned out the Mariadb could not understand the Collation of the database tables, The way I fixed this was to change the collation in the backup mysql dumps to get it to work with Mariadb, you could though uninstall MariaDB and install mysql in it’s place