分类: Mysql/postgreSQL
2011-07-26 12:28:34
再次查看:
mysql> show plugins;
+------------+--------+----------------+--------------+---------+
| Name | Status | Type | Library | License |
+------------+--------+----------------+--------------+---------+
| binlog | ACTIVE | STORAGE ENGINE | NULL | GPL |
| CSV | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MEMORY | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MyISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| MRG_MYISAM | ACTIVE | STORAGE ENGINE | NULL | GPL |
| InnoDB | ACTIVE | STORAGE ENGINE | ha_innodb.so | GPL |
+------------+--------+----------------+--------------+---------+
6 rows in set (0.00 sec)
2. 查看表的类型:
mysql> use web_db;
mysql> show tablse;
随便找个表看类型:
mysql> show create table sys_user;
查看是否有以下字段:
ENGINE=InnoDB AUTO_INCREMENT=4 DEFAULT CHARSET=utf8
如何将MyISAM库 导成 INNODB:
在备份出的 xxx.bak文件中 把 ENGINE=MyISAM 全换成 ENGINE=INNODB
再次导入就可以了。
转换表的命令:
alter table POD engine=innodb;