[RESOLVED] Correct Syntax: Create Database MYISAM

[Rodney_H_]

Hi,

I recently installed WAMP SERVER on my testing PC.

It has PhpMyAdmin, yeah. Unfortunately, everytime it creates a new DB, it does so using the InnoDB storage engine.

I thought MYISAM was the default... ??

So, what is the correct syntax to use to create a new database with MYISAM as the storage engine?

I have tried a few things using the SQL interface, but keep getting syntax errors. Surprisingly enough, I have looked on google, but haven't found an answer. They show how to create the DB, but without mention of syntax to use for the specific storage engine, MyISAM.

Please help.

Thanks.

EDIT: I figured it out. There is a my.conf file, similar to the php.ini file, for your MySQL settings. IN this file is a line where you specify the default engine type. I changed this from INNODB to MYISAM and restarted the server. VOILA!!