Page 1 of 1
Migration from Mariadb to Mysql
Posted: Mon Apr 15, 2024 3:14 pm
by mk45gti
Hi guys, I currently have a zoneminder server running Ubuntu with mariadb and I'm migrating to Azure, I'm thinking about migrating the database to Mysql, I backed up mariadb and when trying to restore to Mysql, several errors were returned and the operation didn't even finish, is there another How to make this migration less traumatic?
Re: Migration from Mariadb to Mysql
Posted: Tue Apr 16, 2024 8:17 am
by dougmccrary
I think the consensus here is use mariadb.
Re: Migration from Mariadb to Mysql
Posted: Tue Apr 16, 2024 8:30 pm
by bbunge
mk45gti wrote: ↑Mon Apr 15, 2024 3:14 pm
Hi guys, I currently have a zoneminder server running Ubuntu with mariadb and I'm migrating to Azure, I'm thinking about migrating the database to Mysql, I backed up mariadb and when trying to restore to Mysql, several errors were returned and the operation didn't even finish, is there another How to make this migration less traumatic?
You should be able to import just the ZM database backup which should be an SQL file Other parts of the Mariadb database likely will not work in MySQL.
With that said it may be better to stay with Mariadb. I also like Debian better than Ubuntu as Ubuntu has gotten too carried away with snaps and etc. Their server setup is not user friendly.