phpBB with MySQL

Recently I was looking to set up a forum. Plenty of them listed here in wikipedia. I went with phpBB.

Atfirst, the Quick Start guide seemed little lengthy. But once started reading, I was able to setup and run the forum in minutes though there was a significant problem I faced while installation. It was setting up the database. I used MySQL with the default storage engine as INNODB. The phpBB installation schema for MySQL created errors if I use the INNODB engine. Tables were not created.

After doing some research, I had to change the storage engine to MYISAM. Then the installation went through and the forum started running good. So if you need to install phpBB with MySQL then you might need to change the storage engine to MYISAM.

If you want the MySQL to use MYISAM all the time, you can set the storage engine in the my.ini file. Command might look like below.

default-storage-engine=MYISAM

Otherwise you can choose to use the MYISAM just for the phpBB installation. And once the installation is over, you can start using the INNODB engine. For this, you can edit the MySQL schema files bundled with phpBB and add the below line as the first line of the schema.

SET storage_engine=MYISAM;

This way the tables will be created without any problem. But I'm not sure if this solves the problem completely. Will post my findings.