From: Kinaan Khan Sherwani
Date: March 27 2012 1:14pm
Subject: Difference between internal data dictionary and table definition file
List-Archive: http://lists.mysql.com/innodb/62
Message-Id: <CAKshL-bYvqH2p-VugU5711ACB7POFguAyOG7vVk5bJn=_QgxEA@mail.gmail.com>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1

Hi,

I am an undergraduate student and want to learn about innodb storage
engine. I came up with this line in mysql reference manual that MySQL
server keeps data dictionary information in .frm files which it stores
in the database
directories, whereas InnoDB also stores the information into its own
data dictionary inside the table space files.I want to know , where
comes the difference between InnoDB internal data dictionary and table
definition ( .frm ) files . Do they store the same information about a
table ?
If no then kindly help me by telling what information is stored in one
that is different from other.

Waiting for a response,
Kinaan Khan Sherwani