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]
