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

数据运维 2023-04-28 醒在深海的猫手机阅读

发现问题今天在工作中，从本地数据库复制表数据到虚拟机 CentOS 6.6 上的数据库时，得到提示： Unknown table engine 'InnoDB' 于是在服务器 MySQL 中查看了引擎： mysql show engines\G 得到： ****

                        <p>发现问题</p>

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

Unknown table engine 'InnoDB'

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

mysql> show engines\G

得到：

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)