Unknown table engine 'InnoDB'的错误，网上查了不少资料，解决方法都是说开启mysql的innodb，下面是官方说明:

  1. Check to see whether you have InnoDB support enabled:

    mysql> show variables like 'have_innodb' ;
    +---------------+-------+
    | Variable_name | Value |
    +---------------+-------+
    | have_innodb   | YES   |
    +---------------+-------+
    1 row in set ( 0.00 sec)




  1. If the value above is DISABLED, then you would need to enable InnoDB.

  2. Open up MySQL's configuration file. On various platforms, the configuration file may differ in file name and location:

    • Windows: $MYSQL_INSTALL_DIRECTORY/my.ini

    • Linux/Unix: /etc/mysql/my.cnf


  3. If the parameter skip-innodb is uncommented/exists, then just comment it out:

    # skip-innodb


  4. Shutdown MySQL server, delete/rename the MySQL logs to refresh the entire server's logging, and restart MySQL server:

    • Linux:

      ~$: /etc/init.d/mysql stop
      ~$: rm /var/lib/mysql/ib_logfile*
      ~$: /etc/init.d/mysql start


    • Windows:
      Go to $MYSQL_INSTALL_DIRECTORY/data and either delete/move the log files with the prefix ib_logfile.