List:General Discussion« Previous MessageNext Message »
From:Egor Egorov Date:August 23 2004 12:36pm
Subject:Re: Innodb table definitions
View as plain text  
Mayuran Yogarajah <mayuran.yogarajah@stripped> wrote:

> 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:

The answer is there, right in your posting: 

> An `.frm' file stores the table definition. 






-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.net http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Egor Egorov
 / /|_/ / // /\ \/ /_/ / /__   Egor.Egorov@stripped
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.net
       <___/   www.mysql.com



Thread
Innodb table definitionsMayuran Yogarajah12 Aug
  • Re: Innodb table definitionsgerald_clark12 Aug
  • Re: Innodb table definitionsEgor Egorov23 Aug