How to change the database storage mechanism in phpmyadmin?

Question

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

I want to change it to InnoDB .

I can change its table after table, but I want to change it once, which affects all tables.

How can I change the database storage mechanism? I tried, but there seems to be no option in phpmyadmin .

Answer 1

When you log in, go to the table you want to change, then click the operations tab. From there you can change the type of storage, as well as several other parameters

Online document

Answer 2

The easiest way to change the default mechanism is to enter phpMyAdmin and then go to Variables → the storage engine

click edit and enter InnoDB .

default storage engine is now InnoDB

http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_storage_engine

Answer 3

Steps:

• Click on the table for which you must change the storage engine.
• Click on operations.
• The ability to change the storage mechanism is inside the set field.

Answer 4

the best answer i got was

The easiest way is to simply go to the mysql configuration file (my.ini on windows, my.cnf on Linux) and just add this: [mysqld] default-storage-engine = InnoDB.

I think this will do the trick easily.

thanks for the help ...........: D

Answer 5

There is no option in phpMyAdmin to change the storage type at a time. You must change each table in the operations tab.

Answer 6

Click on the table name, then click on operations, there you can change the server server one table at a time.

A + Computer Solutions - Belize