Modify the MySQL engine engine

Modify the MySQL tutorial's engine engine

Modify My.ini, add under [mysqld]

Default-storage-engine=innodb

Where the red font part is the name of the engine to be specified.

To modify an engine that has completed a table with SQL statements:

ALTER TABLE TableName TYPE=INNODB

My My.ini file is posted below for your reference (http://www.111cn.net):

[Mysqld]
Basedir=c:program Filesvertrigoservmysql
Datadir=c:program Filesvertrigoservmysqldata
Port =3306
Key_buffer =64m
Max_allowed_packet =1m
Table_cache =128
Sort_buffer_size =512k
Net_buffer_length =8k
Read_buffer_size =256k
Read_rnd_buffer_size =512k
Myisam_sort_buffer_size =68m
Default-storage-engine=innodb

[Mysqldump]
Quick
Max_allowed_packet =116m

[MySQL]
No-auto-rehash
# Remove The next comment character if you are not familiar with SQL
#safe-updates

[Isamchk]
Key_buffer =20m
Sort_buffer_size =20m
Read_buffer =62m
Write_buffer =62m

[Myisamchk]
Key_buffer =20m
Sort_buffer_size =20m
Read_buffer =62m
Write_buffer =62m

[Mysqlhotcopy]
Interactive-timeout