Changing the database engine

[PanSevence]

I heard that Invision Community software is better optimized for MySQL8, and I could achieve better performance. I’m currently using MariaDB and would like to migrate my community to MySQL. The problem is that it’s an active community with a lot of data. I contacted the administrator, and they mentioned that there might be issues with the conversion. Could you guide me on how to go through this process smoothly and migrate to MySQL? I’m convinced that the first thing I need to do is create a full database backup before proceeding.

[Miss_B]

4 minutes ago, PanSevence said:

I’m convinced that the first thing I need to do is create a full database backup before proceeding.

Imo it's always best to make a backup of the database first before any kind of work is done with it.

8 minutes ago, PanSevence said:

I’m currently using MariaDB and would like to migrate my community to MySQL. The problem is that it’s an active community with a lot of data. I contacted the administrator, and they mentioned that there might be issues with the conversion. Could you guide me on how to go through this process smoothly and migrate to MySQL?

Migrating from MariaDB to MySQL it will involve several critical steps to ensure data integrity and minimal downtime. The most important thing imo is to check for compatibility issues such as differences in SQL modes, indexing, syntax variations to just name a few. Then you will have to Install MySQL and configure it to make sure that the MySQL version you choose is compatible with the features used in MariaDB and meets your performance and scalability requirements for your Ipb forum. Then you will have to export the data from MariaDB and import it to MySQL. 

 

.

[Marc]

The best thing for you to do would be to contact your hosting company and have then do this on your behalf, if its not something you are sure about doing yourself. Essentially though, you are looking at a mysql dump, ensuring you keep collation etc intact, and then a restore to the new mysql instance, then test.