1. Please take a little time for this simple survey! Thank you for participating!
    Dismiss Notice
  2. Dear Pleskians, please read this carefully! New attachments and other rules Thank you!
    Dismiss Notice
  3. Dear Pleskians, I really hope that you will share your opinion in this Special topic for chatter about Plesk in the Clouds. Thank you!
    Dismiss Notice

Create a DB with INNODB Engine

Discussion in 'Plesk for Linux - 8.x and Older' started by vigneshv10, Mar 14, 2007.

  1. vigneshv10

    vigneshv10 Guest

    0
     
    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
     
  2. simpliq_adi

    simpliq_adi Guest

    0
     
  3. vigneshv10

    vigneshv10 Guest

    0
     
    Hi,

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

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    You can't do this through Plesk, but you should be able to do this through the commandline mysql shell.
     
  5. vigneshv10

    vigneshv10 Guest

    0
     
    hi breun

    would you be able to help me out from shell?
     
  6. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    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.
     
  7. vigneshv10

    vigneshv10 Guest

    0
     
    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
     
  8. breun

    breun Golden Pleskian

    29
     
    Joined:
    Jun 28, 2005
    Messages:
    1,647
    Likes Received:
    0
    What did you do exactly?
     
Loading...