Re: MySQL creating new tables using wrong engine...
| From: | Adrian Bruce | Date: | Wed, 15 Mar 2006 10:19:51 +0000 |
| Subject: | Re: MySQL creating new tables using wrong engine... | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-41512@lists.php.net to get a copy of this message | ||
--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
Ade
Mark Benson wrote:
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?