解决mysql,Unknown table engine 'InnoDB'的错误
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.
页:
[1]