I'm just trying to move my website from Linode to Google Cloud Platform, I used to use cPanel on my Linode that using MariaDB as the SQL, and when I try to build testing instance on my Google Cloud, I choose to use LAMP by Bitnami that using MySQL 5.7.
I got some problem by using mySQL 5.7, such as mysql need to change to mysqli, sql_mode also need set to "" (if not, i cannot use some SQL function like GROUP BY problem).
After I change the sql_mode on my.cnf, it seems the websites working well. But I just realized that there's another problems when I do update on my data and give them an empty string "". The transactions will cancelled automatically without any warning or failed message.
I wanna ask, is there any way for me to migrate the mySQL5.7 into MariaDB 10, I just wanna make the new instance on Google Cloud be the same with my instance on Linode.
Please help for advice.
Thank you very much,