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