Switch from MyISAM to InnoDB?

[markspace]

Just wondering if it's possible to switch the default type of database engine from MyISAM to InnoDB on the free accounts? I don't see any option on the MySQL control panel or the phpMyAdmin pages, although I may have missed it.

 

[garrettroyce]

I don't see a way of changing the default. You probably just have to write a PHP program/query to change every table, if that's what you're trying to do. Tables can be changed using PHPMyAdmin->operations for the table you want to change. Engine can be specified on table creation as well.

 

[xav0989]

That type of functionality is part of MySQL and is one of it's force (multiple storing engines). It is not disabled under free accounts . However, the default type is set during compilation, thus cannot be changed until a new version of MySQL is made available to the free accounts.