5

mysql中数据库引擎切换

 3 years ago
source link: https://www.wencst.com/archives/517
Go to the source link to view the article. You can view the picture content, updated content and better typesetting reading experience. If the link is broken, please click the button below to view the snapshot at that time.

mysql中数据库引擎切换

作者: wencst 分类: Uncategorized,数据库 发布时间: 2017-04-07 14:21 阅读： 1,590 次

mysql5.1.73

查找mysql支持的引擎

 SELECT
table_name,
table_type,
ENGINE
FROM
information_schema. TABLES
WHERE
table_schema = 'database_name'

修改表引擎为innodb

alter table table_name engine=innodb;

关闭innodb引擎

关闭mysql服务： net stop mysql
找到mysql安装目录下的my.ini文件：
找到default-storage-engine=INNODB 改为default-storage-engine=MYISAM
找到#skip-innodb 改为skip-innodb
启动mysql服务：net start mysql

如果文章对您有用，扫一下支付宝的红包，不胜感激！

欢迎加入QQ群进行技术交流：656897351（各种技术、招聘、兼职、培训欢迎加入）


report

Recommend

About Joyk


Aggregate valuable and interesting links.
Joyk means Joy of geeK