Unknown table engine ‘InnoDB’

Recently I restarted MySQL. All of my InnoDB tables had error:
Unknown table engine ‘InnoDB’

This is how I fixed it:

  1. Ran:  SHOW ENGINES;   and InnoDB was not listed
  2. Checked my.cnf …. it did not have skip-innodb
  3. cd to mysql data directory:  rm ib_logfile* 
  4. restarted MySQL  
  5. Ran:  SHOW ENGINES;   and InnoDB was listed
That fixed it for me

Tagged with:
Posted in Linux, MySQL, SQL

Leave a Reply