From: Rick James
Date: February 4 2013 8:24pm
Subject: RE: Question about Innodb
List-Archive: http://lists.mysql.com/mysql/228916
Message-Id: <582AFBFC517D194489EF570FE21694CF13609BAB@GQ1-EX10-MB03.y.corp.yahoo.com>
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

Meta info about the tables is stored in ibdata1.  Hence, it is not possible=
 to copy just the .ibd file to another database or machine.  5.6.x will rem=
edy this with some export/import commands that do not involve reading/writi=
ng the rows individually.  (Ditto for moving partitions.)

(Sorry, I don't know the exact fields in ibdata1.)=20

> -----Original Message-----
> From: Wayne Leutwyler [mailto:wleutwyl@stripped]
> Sent: Monday, February 04, 2013 11:47 AM
> To: mysql@stripped
> Subject: Question about Innodb
>=20
> Question about InnoDB tables and tablespaces.
>=20
> I have one file per table turned on. Its my understanding that even
> with one file per table turned on, that data is updated in the default
> system ibdata files. What type of data is stored in the ibdata files?
>=20
> Thanks,
>=20
> Walter "Wayne" Leutwyler, RHCT
> Sr. MySQL Database Administrator
> Mobile: 614 519 5672
> Office: 614 889 4956
> E-mail: wayne.leutwyler@stripped
> E-mail: wleutwyl@stripped
> Website: http://penguin-workshop.dyndns.org
>=20
> "Courage is being scared to death, but saddling up anyway." --John
> Wayne