I’ve got an issue for which I could use help if anyone knows the answer.
I have some old PHP code that I use every day on my virtualmin server. It was developed back when PHP 5.6 and MySql 5.7 were the only options!
I upgraded the PHP code to be able to use PHP 7.4, but the database still thinks it needs to use MySql 5.7
By going to the Mariadb config files and including the variable sql=" " I can still update my tables with empty strings. However, when I try to do any kind of a database dump the system won’t allow me to do it.
So before I do a dump of the database I need to comment out the sql=" " and then restart the database. Then everything works as it should.
Is there a way to use this sql=" " to make the database server compatible with the old tables and still allow database dumps by Virtualmin or any other method of dumpng the data?
Thanks in advance!
Dan Lewis