Updating IPB Tables from MYISAM to INNODB

[Nigel Moore]

Hi there,

We are doing some tuning of our MariaDB and we noticed that the DB engine used by IPB is currently set to MYISAM.

We'd like to update this to INNODB but we don't want to do it without making sure we won't break our IPB or any support requirements.

Can you let us know if there are any special requirements to updating all our IPB tables to INNODB?

Or whether we are simply OK to do it using the following standard command for each table:

ALTER TABLE <databasename>.<tablename> engine=InnoDB;

Many thanks!

[Marc]

Not only is there no issue with doing this, we would actually recommend using INNODB. So after taking backups of course, you would indeed update them.

[Nigel Moore]

Great, thank you for the update @Marc Stridgen.