Database storage engine

03-29-2010, 03:07 AM

Hi

few days ago, developers told me that they want a INNODB database. Well if im not wrong MySQL supports innodb storage engine ) but I don't know the way to specifiy this. I only know we can ALTER TABLE to INNODB when we are working with the new database.

The problem is when developers WATCH database throught PHPMYADMIN, they see MYISAM as Storage Database. They see all tables like INNODB but in the bottom of phpmyadmin, they see MYISAM and they are complaining about this.

Comment

I'm sorry but I don't use phpmyadmin, so I am not sure what it is showing. But the database is not MyISAM -- that is impossible. Databases are just directories on the filesystem. Only tables have a storage engine. So maybe there is something confusing about phpmyadmin.