出现提示ERROR 1289 The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have IT worki...

最新推荐文章于 2020-09-26 21:43:04 发布

转载最新推荐文章于 2020-09-26 21:43:04 发布 · 287 阅读

0 ·

CC 4.0 BY-SA版权

原文链接：http://www.cnblogs.com/daipianpian/p/4805195.html

文章标签：

#数据库

本文介绍了一种关闭MySQL数据库的方法：通过编辑my.ini文件中的skip-innodb配置项，并重启MySQL服务来实现。

关闭mysql数据库
在mysql的安装目录中找到my.ini文件
找到skip-innodb，在前面加上#号
保存，重启mysql服务

OK。

转载于:https://www.cnblogs.com/daipianpian/p/4805195.html

确定要放弃本次机会？

福利倒计时

: :

立减 ¥

普通VIP年卡可用

立即使用

dengzhuang8619

关注关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
0
评论
分享

复制链接

分享到 QQ

分享到新浪微博

扫一扫
举报

举报

MySQL提示The InnoDB feature is disabled需要开启InnoDB的解决方法

12-15

本文实例分析了MySQL提示The InnoDB feature is disabled需要开启InnoDB的解决方法。分享给大家供大家参考，具体如下：一、问题：建立数据表报错： ERROR 1289 : The ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working 开启DOD命令行，登录（关于MySQL使用DOS命令行登录方法可查看前一篇《MySQL基于DOS命令行登录操作实例(图文说明)》）并查看了下代码如下:SHOW variables like “have_%”;

Plugin ‘InnoDB’ is disabled. Unknown/unsupported storage engine: INNODB

01-07

200215 20:35:10 [Note] Plugin 'InnoDB' is disabled. 200215 20:35:10 [ERROR] Unknown/unsupported storage engine: INNODB 场景描述 https://blog.csdn.net/qq_33840251/article/details/104333716 my.ini更改...

参与评论您还未登录，请先登录后发表或查看评论

解决 The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it w...

weixin_34104341的博客

08-02

262

事由：迁移server的时候须要操作数据库。将数据库也进行迁移，在新server中导入数据的时候提示 The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working 原因是 mysql 配置文件禁掉了这个选项！这时候。仅仅须要在 MYSQL 安装文件夹下找到 ...

MySQL恢复数据报错　#1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to hav...

weixin_34205076的博客

01-05

207

Step 1. Stop MySQL serviceStep 2:打开my.ini 找到 skip-innodb 并在其前加'#'号Step 3: Restart MySQL service

#1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to hav

weixin_34411563的博客

10-11

158

今天上午在配置框架时候，导入数据结构时，出现如上错误。在LINUX上正常的SQL语句到WINDOWS下有mysql innodb问题。在有框架其中一个表想使用外键、事务等功能，所以存储类型设置的是 ENGINE=InnoDB数据库版本 5.0.45 默认存储引擎是 MyISAM它基于更老的ISAM代码，但有很多有用的扩展。（注意MySQL 5.1不支持ISAM）。每个MyISAM在磁盘上存储成三...

解决#1289 - The \'InnoDB\' feature is disabled; you need MySQL built with \'InnoDB\' to have it working的问题

小崔真好的专栏

12-04

1941

今天安装需要创建mysql数据库的php程序时，出现提示：#1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working。然后网上搜了下解决办法：找到mysql安装目录，找到my.ini文件，打开之后搜索skip-innodb ，原因就是这个属性开启了，只

mysql 提示INNODB错误的解决方法

01-19

you need MySQL built with ‘InnoDB’ to have it working；是mysql配置文件禁掉了这个选项！关闭mysql数据库 在mysql的安装目录中找到my.ini文件找到skip-innodb，在前面加上#号保存，开启mysql数据库！搞定...

MySQL启动报错问题InnoDB:Unable to lock/ibdata1 error

01-21

2016-03-03T00:02:30.483100Z 0 [Note] InnoDB: Check that you do not already have another mysqld process using the same InnoDB data or log files. 终端不断地重复打印上面的错误日志，从错误日志看起来似乎有...

The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

漂浮

09-12

2697

The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

导入数据库时出现[Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it...

weixin_30521649的博客

01-30

346

导入数据库时出现 [Err] 1289 - The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working 解决办法：Step 1: 找到mysql安装目录下的my.ini文件打开 Step2: ctrl+f找到 skip-innodb 并在其前加'#'号 ...

解决The InnoDB feature is disabled; you need MySQL built with InnoDB

hududumo

03-29

226

解决TheInnoDBfeatureisdisabled;youneedMySQLbuiltwithInnoDB 在MYSQL下创建事务，存储过程，触发器，主外健的时候，数据表的类型必须是InnoDB的，但有的时候MYSQL不支持这种类型，会出现一种错误！ MySQL 出现如下语句：The InnoDB feature is disabled; you need MySQL ...

解决Navicat数据传输问题:The‘InnoDB’feature is disabled; you need MySQL built with ‘InnoDB'...

亜侖的专栏

09-09

1272

Navicat 8 for MySQL 选择传输数据（转移数据库）时出现如下语句：The ‘InnoDB’ feature is disabled; you need MySQL built with ‘InnoDB’ to have it working；原因是mysq

【原】The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

小兵qwer的专栏

01-23

463

今天安装php程序的时候，突然mysql报出了个错误：The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working 。在命令行查看了下SHOW variables like "have_%"; 发现innodb不能使用。然后又查看了下，innodb插件是否安装了。发现已

The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it

xxtianxiaxin的专栏

10-29

287

异常：java.sql.SQLException: The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working SQL:"CREATE TABLE `"+time+"` (" + "`ID` int(11) NOT NULL auto_increment COMME...

处理The ‘InnoDB’ feature is disabled； you need MySQL built with ‘InnoDB’ to have it working；问题

追梦小明

09-26

222

关闭数据库，找到MySQL安装路径下的 my.ini ctrl+f找到skip-innodb 在前面加上#号，如上图

解决 The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working

大事龙

12-29

2159

事由：迁移服务器的时候需要操作数据库，将数据库也进行迁移，在新服务器中导入数据的时候提示The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working原因是 mysql

解决The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it (http://ruijunsu)

u013629497的专栏

02-13

577

mysql出现如下语句：The 'InnoDB' feature is disabled; you need MySQL built with 'InnoDB' to have it working；是mysql配置文件禁掉了这个选项！关闭mysql数据库 在mysql的安装目录中找到my.ini文件找到skip-innodb，在前面加上#号保存，

导入sql报错：The ‘InnoDB‘ feature is disabled； you need MySQL built with ‘InnoDB‘ to have it working解决办法

SWXY33的博客

07-06

520

一、先查看mysql数据库物理文件存放位置找到mysql的配置文件my.ini 找到mysql目录找到my.ini文件搜索定位到skip-innodb,在前面加上# ---->#skip-innodb 二、打开任务管理器（快捷键Ctrl+Shift+Esc），重启mysql 三、再次导入要运行的mysql文件，就显示成功啦！四、希望可以帮助到更多遇到此问题的博友。喜欢的点个赞呀(づ￣3￣)づ╭❤～ ...

InnoDB Database creation was aborted with error Generic error. You may need to delete the ibdata1 file before trying to start up again