Modify Mysql Database Engine as InnoDB method _mysql

For MySQL databases, you must use the InnoDB engine if you want to use transactions and row-level locks. If you want to use Full-text indexing, you must use MyISAM. InnoDB's practicality, security, stability is higher but the efficiency than myisam slightly worse, but some function is MyISAM not. Modify the MySQL engine for InnoDB, you can use foreign keys, transactions and other functions, high performance. This article mainly describes how to modify the MySQL database engine for InnoDB, and then we begin to introduce.

First modify the My.ini and add the following under [Mysqld]:

The blue font is the name of the database engine you want to specify.

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

My My.ini file is posted below for your reference:

[Mysqld] 
 
Basedir=c:\program files\vertrigoserv\mysql\ 
 
datadir=c:\program files\vertrigoserv\mysql\data\ 
 
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 
 
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] 
 

Following the code hints above, we will be able to successfully modify the MySQL database engine for InnoDB. This article is introduced here, I am sure will bring you harvest!