MySQL 如何在phpmyadmin中更改数据库的存储引擎？
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/6921506/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
how to change storage engine of database in phpmyadmin?
提问by Kanishka Panamaldeniya
I have a MySQL database. The default storage engine is MyISAM.
我有一个 MySQL 数据库。默认存储引擎是MyISAM.
I want to change it to InnoDB.
我想把它改成InnoDB.
I can change it table by table , but i want to change it one time that affect all the tables .
我可以一张一张地改变它，但我想改变它一次，影响所有表。
How can I change the database storage engine? I tried it but seems there is no option in phpmyadmin.
如何更改数据库存储引擎？我试过了，但似乎没有选项phpmyadmin。
回答by Gurey
The easiest way to change the default engine is to log on phpMyAdminand then go to Variables >> storage engine
更改默认引擎最简单的方法是登录phpMyAdmin，然后进入变量>>存储引擎
click editand type InnoDB.
单击编辑并输入InnoDB。
the default storage engine is now InnoDB
默认存储引擎现在是 InnoDB
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_storage_engine
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_storage_engine
回答by nidhin
When logged in go to the table you want to change then click the operations tab. From there you can change the storage type, as well as a few other options
登录后，转到要更改的表，然后单击操作选项卡。从那里您可以更改存储类型以及其他一些选项
回答by Nil Patil
Steps:
脚步：
- Click on the table for which you have to change the storage engine.
- Click on operations.
- Option to change the storage engine is inside the field set
- 单击您必须更改存储引擎的表。
- 点击操作。
- 更改存储引擎的选项位于字段集内
回答by Kanishka Panamaldeniya
the best answer i got was
我得到的最好的答案是
The easiest way is just to go to the mysql config file (my.ini in windows, my.cnf in Linux) and just add this: [mysqld] default-storage-engine=InnoDB .
最简单的方法是转到 mysql 配置文件（Windows 中的 my.ini，Linux 中的 my.cnf）并添加以下内容： [mysqld] default-storage-engine=InnoDB 。
i think that will do the trick easily .
我认为这很容易做到。
thanks for the help........... :D
感谢您的帮助....... :D
回答by Earlin THimbriel
Click on the table name, then click on operations, there you can change the server engine one table at a time.
单击表名，然后单击操作，可以一次更改一张表的服务器引擎。
A+ Computer Solutions- Belize
A+ 计算机解决方案 - 伯利兹
回答by James
There is no option in phpMyAdmin to change the storage type at a time. You have to change each table in operations tab.
phpMyAdmin 中没有选项可以一次更改存储类型。您必须在操作选项卡中更改每个表。
