Create a DB with INNODB Engine

[vigneshv10]

Hi

i would like to know how to create a database with Innodb Engine. Now my default engine is MyISAM, is there a way to create a database with INNODB engine using plesk?

otherwise how do i create a database with INNODB engine?

thanks in advance.

vignesh

 

[simpliq_adi]

Hello,

See this URL:

http://dev.mysql.com/doc/refman/5.0/en/using-innodb-tables.html

 

[vigneshv10]

Hi,

Those are to create tables.. but how do i create a DB?

 

[breun]

You can't do this through Plesk, but you should be able to do this through the commandline mysql shell.

 

[vigneshv10]

hi breun

would you be able to help me out from shell?

 

[breun]

I was wrong, the InnoDB type is only associated with tables, not with databases. You can just create the database through Plesk. When you create your tables you should specify InnoDB as the storage engine.

Like simpliq_adi said: see the docs for the CREATE TABLE syntax.

 

[vigneshv10]

i did that, but still my database shows as MYISAM. i read somwhere u need to change the default database engine to INNODB to create a database with INNODB engine...still searching how to do that

 

[breun]

What did you do exactly?