Hosting Website - No InnoDb tables

[sfast]

I use PHP and Mysql. I deal with transactions but I cannot use InnoDb tables because my hosting company doesn't support InnoDb tables. They want me to use MyISAM which is by default on the westing website.

Is there any other way to work out other than going for new Hosting website?

Thanks

[sfast]

Somebody please reply!

[coopster]

Have you tried creating a table with INNODB storage engine type?

If you try to use a storage engine [dev.mysql.com] that is not compiled in or that is compiled in but deactivated, MySQL instead creates a table using the default storage engine, usually MyISAM.

If this is your particular case, then no, you don't have a lot of choice but to move to a different host. You can simulate your own transactions [webmasterworld.com] using table locking but having more control over your database moving into the future is something you are going to find being a requirement as opposed to a benefit.