Re: [PHP-DB] MySQL creating new tables using wrong engine...

2006-03-15 Thread Adrian Bruce
--default-storage-engine option in your options file (my.ini) where engine is the the type of table engine you want to use, in your case MYISAM. If you cant change that then specify the engine type every time you create a table: create table table_name{ . } TYPE=myisam; Regards Ad

[PHP-DB] MySQL creating new tables using wrong engine...

2006-03-15 Thread Mark Benson
I have run into an issue where I keep getting InnoDB tables everytime I create a new table in PHPMyAdmin, and I want MyISAM tables. It's very annoying. Anyone got any suggestions as to what I might have done that made MySQL or PHPMyAdmin do this? -- Mark Benson http://homepage.mac.com/markbe