MYSQL5.6更改引擎(InnoDB,MyISAM)的方法
云服务器安装的MYSQL5.6数据库默认为MyISAM引擎,有些程序需要InnoDB引擎,
MyISAM引擎更改InnoDB引擎 方法如下:
修改配置文件my.ini 该配置文件在D盘MYSQL安装目录下 打开MY.INI 搜索default-storage-engine default-storage-engine=MyISAM 修改为 default-storage-engine=InnoDB 然后下面一行是: default-tmp-storage-engine=InnoDB -------------------------修改成功后是下面这样的--------------------------------------- default-storage-engine=InnoDB default-tmp-storage-engine=InnoDB ----------------------------------------------------------------- 不仅如此,还需要删除以下,把下面凡是loose-开头的全部删除,否则MYSQL无法启动,删除后保存my.ini,就可以启动MYSQL服务了
loose-skip-innodb loose-innodb-trx=0 loose-innodb-locks=0 loose-innodb-lock-waits=0 loose-innodb-cmp=0 loose-innodb-cmp-per-index=0 loose-innodb-cmp-per-index-reset=0 loose-innodb-cmp-reset=0 loose-innodb-cmpmem=0 loose-innodb-cmpmem-reset=0 loose-innodb-buffer-page=0 loose-innodb-buffer-page-lru=0 loose-innodb-buffer-pool-stats=0 loose-innodb-metrics=0 loose-innodb-ft-default-stopword=0 loose-innodb-ft-inserted=0 loose-innodb-ft-deleted=0 loose-innodb-ft-being-deleted=0 loose-innodb-ft-config=0 loose-innodb-ft-index-cache=0 loose-innodb-ft-index-table=0 loose-innodb-sys-tables=0 loose-innodb-sys-tablestats=0 loose-innodb-sys-indexes=0 loose-innodb-sys-columns=0 loose-innodb-sys-fields=0 loose-innodb-sys-foreign=0 loose-innodb-sys-foreign-cols=0
|