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 remedy this with some export/import commands that do not involve reading/writing the rows individually. (Ditto for moving partitions.)
(Sorry, I don't know the exact fields in ibdata1.) > -----Original Message----- > From: Wayne Leutwyler [mailto:wleut...@columbus.rr.com] > Sent: Monday, February 04, 2013 11:47 AM > To: mysql@lists.mysql.com > Subject: Question about Innodb > > Question about InnoDB tables and tablespaces. > > 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? > > Thanks, > > Walter "Wayne" Leutwyler, RHCT > Sr. MySQL Database Administrator > Mobile: 614 519 5672 > Office: 614 889 4956 > E-mail: wayne.leutwy...@gmail.com > E-mail: wleut...@columbus.rr.com > Website: http://penguin-workshop.dyndns.org > > "Courage is being scared to death, but saddling up anyway." --John > Wayne -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql
