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/
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
