Mysql实例MySQL启动时InnoDB引擎被禁用了的解决方法

《Mysql实例MySQL启动时InnoDB引擎被禁用了的解决方法》要点：
本文介绍了Mysql实例MySQL启动时InnoDB引擎被禁用了的解决方法，希望对您有用。如果有疑问，可以联系我们。

MYSQL实例发现问题

MYSQL实例今天在工作中,从本地数据库复制表数据到虚拟机 CentOS 6.6 上的数据库时,得到提示：

MYSQL实例
Unknown table engine 'InnoDB'

MYSQL实例于是在服务器 MySQL 中查看了引擎：

MYSQL实例
mysql> show enginesG

MYSQL实例得到：

MYSQL实例
*************************** 1. row ***************************
  Engine: MyISAM
  Support: DEFAULT
  Comment: MyISAM storage engine
Transactions: NO
   XA: NO
 Savepoints: NO
*************************** 2. row ***************************
  Engine: CSV
  Support: YES
  Comment: CSV storage engine
Transactions: NO
   XA: NO
 Savepoints: NO
*************************** 3. row ***************************
  Engine: MEMORY
  Support: YES
  Comment: Hash based,stored in memory,useful for temporary tables
Transactions: NO
   XA: NO
 Savepoints: NO
*************************** 4. row ***************************
  Engine: BLACKHOLE
  Support: YES
  Comment: /dev/null storage engine (anything you write to it disappears)
Transactions: NO
   XA: NO
 Savepoints: NO
*************************** 5. row ***************************
  Engine: MRG_MYISAM
  Support: YES
  Comment: Collection of identical MyISAM tables
Transactions: NO
   XA: NO
 Savepoints: NO
*************************** 6. row ***************************
  Engine: PERFORMANCE_SCHEMA
  Support: YES
  Comment: Performance Schema
Transactions: NO
   XA: NO
 Savepoints: NO
*************************** 7. row ***************************
  Engine: ARCHIVE
  Support: YES
  Comment: Archive storage engine
Transactions: NO
   XA: NO
 Savepoints: NO
*************************** 8. row ***************************
  Engine: FEDERATED
  Support: NO
  Comment: Federated MySQL storage engine
Transactions: NULL
   XA: NULL
 Savepoints: NULL
*************************** 9. row ***************************
  Engine: InnoDB
  Support: NO
  Comment: Supports transactions,row-level locking,and foreign keys
Transactions: NULL
   XA: NULL
 Savepoints: NULL
rows in set (0.00 sec)

MYSQL实例在 InnoDB 的 Supports 为 NO

MYSQL实例解决方法

MYSQL实例编辑 my.cnf

MYSQL实例
[root@localhost mysql]# vim /etc/my.cnf

MYSQL实例把其中 innodb = OFF 改为 innodb = ON

MYSQL实例同时把 skip-innodb 注释掉即可.

MYSQL实例总结

MYSQL实例以上就是这篇文章的全部内容了,希望本文的内容对大家的学习或者工作能带来一定的帮助,如果有疑问大家可以留言交流,谢谢大家对编程之家PHP的支持.

（编辑：李大同）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!