Yeah I though about that too. But i am not able to find the command for creating a database in an innodb mode.?? DOu have an idea about it Grant??.
thank u kamran >===== Original Message From "Quinlan, Grant" <[EMAIL PROTECTED]> ===== >I am a newbie myself, so please someone correct me if I am wrong, but here >is how I understand it: >A MySQL installation can support several databases. The system tables are >always in a system database that uses tables of type ISAM. You create >another database of type InnoDB, in which you keep your InnoDB tables. > >With the ISAM database every table is stored in a separate file. With InnoDB >all tables in the database are stored in one or more database files, and >data from single table may be stored within several of these database files. > >To use InnoDB tables and other InnoDB features you must first create an >InnoDB database, then copy your tables into new tables in the InnoDB >database. > > Grant Q > >-----Original Message----- >From: azamka [mailto:[EMAIL PROTECTED] >Sent: Tuesday, July 08, 2003 10:59 AM >To: [EMAIL PROTECTED] >Subject: creating table type innodb > > >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. > >Thank you in advance > >Kamran > > > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] > >-- >MySQL General Mailing List >For list archives: http://lists.mysql.com/mysql >To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]