Any way to make InnoDB the default engine for creating tables in a 3rd party controlled MySQL db?
Posted on 2008-06-17
I had the problem that a bunch of tables in my database got created using the MyISAM engine, which rendered my foreign keys useless. With the help of an expert on this site, I have successfully converted my MyISAM tables to engine=InnoDB. The database was created by my ISP and I do not have any kind of control over it, other than what I can set or unset within my own database.
Is there any way to set a database-level parameter or setting such that the:
CREATE TABLE XYZZY (id int, col1 int);
defaults to engine=InnoDB without the need to explicitly add the engine=InnoDB parameter to the end of each create table statement?