我用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开头的日志文件重新启动。如果解决您的问题请采纳,祝学习愉快!
相似问题
回答 1
回答 1