如何在mysql中启用INNODB

2021-11-20 00:00:00 sql transactions mysql innodb

当我在 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

相关文章