InnoDB Is Disabled By Default

Contrary to what appears to be claimed in the cPanel forums, InnoDB is not disabled by default on cPanel servers in later versions of MySQL 5…at least it shouldn’t be. If you get errors in your application due to InnoDB storage not being enabled, log into your MySQL console and run:

show engines;

You should see a list of all the storage engines MySQL supports, and you may see something like this:

| InnoDB     | DISABLED | Supports transactions, row-level locking, and foreign keys     |

If you do, there are generally two things that would cause this:

1. Check my.cnf for skip-innodb. If it’s there, remove that line and restart MySQL

2. Your ibdata files are corrupted. Try moving the ibdata* files out of /va