Modify mysql engine

Modify the mysql tutorial engine

Modify my. ini and add

Default-storage-engine = INNODB

The red font indicates the engine name to be specified.

Use SQL statements to modify the engine of a table:

Alter table tableName type = InnoDB

My. ini file for reference (http://www.zhutiai.com) is posted below ):

[Mysqld]
Basedir = C: Program FilesVertrigoServMysql
Datadir = C: Program FilesVertrigoServMysqldata
Port = 3306
Key_buffer = 64 M
Max_allowed_packet = 1 M
Table_cache = 128
Sort_buffer_size = 512 K
Net_buffer_length = 8 K
Read_buffer_size = 256 K
Read_rnd_buffer_size = 512 K
Myisam_sort_buffer_size = 68 M
Default-storage-engine = INNODB

[Mysqldump]
Quick
Max_allowed_packet = 116 M

[Mysql]
No-auto-rehash
# Remove the next comment character if you are not familiar with SQL
# Safe-updates

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

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

[Mysqlhotcopy]
Interactive-timeout