Migration from Mariadb to Mysql
Migration from Mariadb to Mysql
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?
-
- Posts: 1236
- Joined: Sat Aug 31, 2019 7:35 am
- Location: San Diego
Re: Migration from Mariadb to Mysql
I think the consensus here is use mariadb.
Re: Migration from Mariadb to Mysql
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.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?
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.