如何在MySQL中启用INNODB [英] How to enable INNODB in mysql

问题描述

当我在MySQL中执行查询时，它返回一条错误消息，说明未启用InnoDB.当我单击存储引擎时，InnoDB被禁用.

When I execute a query in MySQL it returns an error saying that InnoDB is not enabled. When I clicked the storage engine, the InnoDB was disabled.

如何启用InnoDB?

How do I enable InnoDB?

推荐答案

您需要在my.cnf文件中启用它，然后重新启动服务器:

You need to enable it in my.cnf file, then restart your server:

http://dev.mysql.com/doc/refman/5.1 /en/innodb-parameters.html#option_mysqld_innodb

或者您可以在运行时加载InnoDB插件:

Or you can load an InnoDB plugin during runtime:

http://dev.mysql.com/doc/refman/5.1 /en/replacing-builtin-innodb.html

这篇关于如何在MySQL中启用INNODB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！