解决mysql,Unknown table engine 'InnoDB'的错误

11lxm

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

• 　　Check to see whether you have InnoDB support enabled:
  mysql> show variables like 'have_innodb';+---------------+-------+| Variable_name | Value |+---------------+-------+| have_innodb   | YES   |+---------------+-------+1row in set (0.00sec)
  

• 　　If the value above is DISABLED, then you would need to enable InnoDB.
  
• 　　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
    
  
  
• 　　If the parameter skip-innodb is uncommented/exists, then just comment it out:
  # skip-innodb
  
• 　　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.