如何在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屋！