How can I configure ISPConfig to use MySQL 8. I'm creating own server for dev productions of my sites on CMS 1C-Bitrix. This CMS requires MySQL 8. It can work with MariaDB, if it was installed as new site. But when I'm trying to restore backup of a site that used MySQL 8, I get an error on a screenshot. How can I use MySQL 8 with ISPConfig?
From the error message, it does not seem like you need MySQL 8, especially if the software you use supports MariaDB in general; it just looks like you exported an SQL dump with a collation that MariaDB does not understand. Change the collation to a compatible one in your SQL dump before importing the SQL dump into the new database.
It is - this coollation changed in Mysql 8. I have the same problem trying to restore Mysql 8 dump on Mysql 5.7. I know I can. But when I transfer the site to the master production, I think, I will forget to convert back. So I'd like to have the same Mysql on ISPConfig server.
We do not provide install gzuides for MySQL 8 as MariaDB is used much more widely and the default database of all supported Linux distributions. ISPConfig should work with MySQL 8, though, but it might be that you need an ISPConfig dev branch version due to incompatible changes MySQL made with password encryption, which just have been implemented lately. The better approach would be to keep MariaDB, and take care when dumping the databases that you use the correct parameters for mysqldump or phpmyadmin to create compatible SQL dumps.
You can choose the ispconfig branch when using the auto-installer and you can also choose the branch when doing an ISPConfig update with: ispconfig_update.sh --force command.
