欢迎您访问程序员文章站本站旨在为大家提供分享程序员计算机编程知识!
您现在的位置是: 首页  >  IT编程

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

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

一、先查看mysql数据库物理文件存放位置导入sql报错:The ‘InnoDB‘ feature is disabled; you need MySQL built with ‘InnoDB‘ to have it working解决办法

找到mysql的配置文件my.ini导入sql报错:The ‘InnoDB‘ feature is disabled; you need MySQL built with ‘InnoDB‘ to have it working解决办法
找到mysql目录找到my.ini文件搜索定位到skip-innodb,在前面加上# ---->#skip-innodb
二、打开任务管理器(快捷键Ctrl+Shift+Esc),重启mysql
导入sql报错:The ‘InnoDB‘ feature is disabled; you need MySQL built with ‘InnoDB‘ to have it working解决办法
三、再次导入要运行的mysql文件,就显示成功啦!
导入sql报错:The ‘InnoDB‘ feature is disabled; you need MySQL built with ‘InnoDB‘ to have it working解决办法
导入sql报错:The ‘InnoDB‘ feature is disabled; you need MySQL built with ‘InnoDB‘ to have it working解决办法
四、希望可以帮助到更多遇到此问题的博友。喜欢的点个赞呀(づ ̄3 ̄)づ╭❤~

本文地址:https://blog.csdn.net/SWXY33/article/details/107160771