Each |MyISAM| table is stored on disk in three files. The files have names that
begin with the table name and have an extension to indicate the file type.
An `.frm' file stores the table definition. The data file has an `.MYD'
(MYData) extension. The index file has an `.MYI' (MYIndex) extension.
My question is, why does MySQL create a .frm (table definition) for a table if that table is of type InnoDB. For example, consider the following:
use test;
CREATE TABLE mytest (
id INT NOT NULL PRIMARY KEY AUTO_INCREMENT,
name VARCHAR(255) NOT NULL
) TYPE=InnoDB;This created inside the 'test' directory: mytest.frm
Can anyone provide a reason for this.
thanks, Mayuran
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
