我用wamp mysql配置文件默认myisam 配置里怎么改成innodb

来源:4-3 MySQL常用存储引擎之InnoDB

心情心不晴

2017-08-09 22:33:37

myisam_sort_buffer_size = 32M

;Path to mysql install directory

basedir="D:/wamp64/bin/mysql/mysql5.7.14"

log-error="D:/wamp64/logs/mysql.log"

;Verbosity Value  1 Errors only, 2  Errors and warnings , 3 Errors, warnings, and notes

log_error_verbosity=2

;Path to data directory

datadir="D:/wamp64/bin/mysql/mysql5.7.14/data"


;Path to the language

;See Documentation:

; http://dev.mysql.com/doc/refman/5.7/en/error-message-language.html

lc-messages-dir="D:/wamp64/bin/mysql/mysql5.7.14/share"

lc-messages=en_US


; The default storage engine that will be used when create new tables

default-storage-engine=MYISAM

这里改成default-storage-engine=InnoDB 吗?????

; New for MySQL 5.6 default_tmp_storage_engine if skip-innodb enable

; default_tmp_storage_engine=MYISAM


写回答

1回答

guly

2017-08-10

你好,步骤如下:

首先修改my.ini中在default-storage-engine=MYISAM 为default-storage-engine=INNODB ;然后重新启动
如果 INNODB 模式如果不能启动,删除data目录下ib开头的日志文件重新启动。如果解决您的问题请采纳,祝学习愉快!

0

0 学习 · 2569 问题

查看课程