title: MySQL unknown table engine innodb
body: <p>I am trying to migrate a test website on drupal onto a live server on Amazon ec2. I migrated the database using phpmyadmin, and tried to access the site. I got this error:</p>
  
  <blockquote>
    <p>PDOException: SQLSTATE[42000]: Syntax error or access violation: 1286 Unknown table engine 'InnoDB': SELECT expire, value FROM {semaphore} WHERE name = :name; Array ( [:name] => variable_init ) in lock_may_be_available() (line 167 of /var/www/includes/lock.inc).</p>
  </blockquote>
  
  <p>I believe the problem here is that MySQL doesn't have InnoDB. I have looked through the my.cnf file and there is no line that says <code>skip-innodb</code>.</p>
  
  <p>I have tried <code>show engines</code> and it showed a bunch of engines but not innodb.
  I have tried restarting my server and deleting the logfile, just like has been suggested previously, but that didn't work.</p>
  
  <p>Maybe what needs to be done is to somehow install the Innodb engine. Could you tell me how I may do that?</p>