Description
Installation of Craft fails on hosts or systems that don't support the MyISAM storage engine. The searchindex table appears to be the only table that uses MyISAM, all the other tables use InnoDB.
I realize that not many hosts have MyISAM disabled, but on the off chance that you come across one that does, the error messages MySQL returns are less than clear.
I my case I was receiving an error that incorrectly indicated the system was out of disk space.
Switching the storage engine to InnoDB and creating the searchindex table manually solved the issue.
Steps to reproduce
- Attempt any installation or migration on/to a host running MySQL with MyISAM support disabled (i.e. Microsoft Azure MySQL instances)
- You will likely receive an error along the lines of "MySQL Error Code: 1030. Got error -1 from storage engine;"
Additional info
- Craft version: Any
- PHP version: Any
- Database driver & version: MySQL without MyISAM storage engine support
Description
Installation of Craft fails on hosts or systems that don't support the MyISAM storage engine. The
searchindextable appears to be the only table that uses MyISAM, all the other tables use InnoDB.I realize that not many hosts have MyISAM disabled, but on the off chance that you come across one that does, the error messages MySQL returns are less than clear.
I my case I was receiving an error that incorrectly indicated the system was out of disk space.
Switching the storage engine to InnoDB and creating the
searchindextable manually solved the issue.Steps to reproduce
Additional info