At 12:58 -0500 7/8/03, azamka wrote:
>Hi everyone,
>
>I am trying to create tables with type innodb. I created a database and all
>the tables of type ISAM. Now I am at the point of making relations and
>establish refrential integrity. For that ofcourse I have to change the tables
>in the Innodb type. I did that with the commad "alter table tablename type =
>innodb". Command runs fine but the table type doesnt change. I tried to create
>a new table of type innodb but its not working either. I dont know what the
>problem is. Do we have any command to enable the innodb property or what?? I
>am stuck badly. Please help.
Your server may have no InnoDB capabilities. What do you see for
the output of this query:
SHOW VARIABLES LIKE 'have_innodb';
It should say "YES". If it's "NO", your server does not support InnoDB
at all. If it's "DISABLED", your server supports InnoDB but InnoDB was
disabled at server startup time; in this case, look for a skip-innodb
in your option files, remove it, and restart the server.
If your server doesn't support InnoDB ("NO"), you need to get one that
does. Prior to MySQL 3.23, you need MySQL Max. As of MySQL 4.0, InnoDB
support is standard.
>
>Thank you in advance
>
>Kamran
--
Paul DuBois, Senior Technical Writer
Madison, Wisconsin, USA
MySQL AB, www.mysql.com
Are you MySQL certified? http://www.mysql.com/certification/
