如何在phpmyadmin中更改数据库的存储引擎? [英] how to change storage engine of database in phpmyadmin?

问题描述

我有一个MySQL数据库.默认存储引擎为MyISAM.

I have a MySQL database. The default storage engine is MyISAM.

我想将其更改为InnoDB.

我可以逐表更改它，但是我想一次更改它影响所有表.

I can change it table by table , but i want to change it one time that affect all the tables .

如何更改数据库存储引擎?我试过了，但是phpmyadmin中似乎没有任何选择.

How can I change the database storage engine? I tried it but seems there is no option in phpmyadmin.

推荐答案

登录后，转到要更改的表，然后单击操作"选项卡.在这里，您可以更改存储类型以及其他一些选项

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

在线文档

这篇关于如何在phpmyadmin中更改数据库的存储引擎?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！