Re: MySQL creating new tables using wrong engine...

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



--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?


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php


[Index of Archives]     [PHP Home]     [PHP Users]     [Postgresql Discussion]     [Kernel Newbies]     [Postgresql]     [Yosemite News]

  Powered by Linux