My question is this:

I am using "InnoDB" type in mysql databse, can i convert it to some other databse type? 2ndly how many types are available other than InnoDB for mysql databse.


Custom Web Development
SEO

I usually use MyISAM. Innodb is only needed if you are going to develop something very special, which might use transactions.

ALTER table <your_table> type=MyISAM;

MySQL has six table types: MyISAM, MERGE, ISAM, HEAP, InnoDB, BDB or BerkeleyDB Tables

Ibbo

From MySQL.com:

http://dev.mysql.com/doc/refman/5.0/...e-engines.html

Try this :
ALTER table <your_table> engine=<engine type>;
'type' is deprecated.

You already got the storage engine types.
There are a few more in version 5, such as cluster, archive, federated.
http://dev.mysql.com/doc/refman/5.0/...e-engines.html

did you has any tutorial for it? i'm still newbie...
can u help me

Try download MySQL Administrator. It will make your life much easier in terms of changing database or table attributes. You should be able to find it from MySQL official home page. Have Fun