In mysql all InnoDB table/data info live within ibdata1. The only manifestation of any InnoDB table outside of ibdata1 is the .frm file of the InnoDB table. Copying all InnoDB data at once requires copying all of /var/lib/mysql.
For Linux server all mysql data files are stored on /var/lib/mysql and for xampp on windows these can be found on path_to_xampp/mysql/data/
Copying an individual InnoDB table is totally impossible. You must mysqldump to extract a dump of the table as a logical representation of the data and its corresponding index definitions. You would then load that dump to another database on the same server or another server.
For more info read here : http://dba.stackexchange.com/questions/15531/why-does-innodb-store-all-databases-in-one-file
For Linux server all mysql data files are stored on /var/lib/mysql and for xampp on windows these can be found on path_to_xampp/mysql/data/
Copying an individual InnoDB table is totally impossible. You must mysqldump to extract a dump of the table as a logical representation of the data and its corresponding index definitions. You would then load that dump to another database on the same server or another server.
For more info read here : http://dba.stackexchange.com/questions/15531/why-does-innodb-store-all-databases-in-one-file
No comments:
Post a Comment