Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Can't Convert Myisam To Innodb

forums › forums › SQLyog › Using SQLyog › Can't Convert Myisam To Innodb

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • February 16, 2006 at 6:28 am #9480
      kreecha_pu
      Member

      Hi,

      I have a database all tables are MYISAM when i tried to alter the tables none of them would want to be Innodb. Hence i can not create a relationship. Any idea why?

      Thank you,

      Kai

    • February 16, 2006 at 12:52 pm #20557
      peterlaursen
      Participant

      Maybe InnoDB is not enabled with the server configuration?

      SGLyog menu .. tools .. show .. variables. Check for 'has_innodb' system variable. And in some of the 'bundled' LAMP/WAMP distributions innobd is not available at all. Also some ISP's disable it.

      You will need to provide more info about the server!

    • February 17, 2006 at 8:54 am #20558
      kreecha_pu
      Member

      Thank you Peter Laursen, you were right now it works. Kreecha_pu

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.