List:InnoDB Storage Engine« Previous MessageNext Message »
From:Reindl Harald Date:November 12 2013 9:34am
Subject:Re: Role of ibdata1 for DB with innodb_file_per_table
View as plain text  

Am 12.11.2013 07:43, schrieb Wiebe Cazemier:
> I unfortunately probably already know what the answer is, but to be sure:
> Does the ibdata1 file contain information for databases of which all tables 
> are InnoDB and created with innodb_file_per_table? 

http://dev.mysql.com/doc/refman/5.6/en/glossary.html#glos_system_tablespace

> In other words, when I remove ibdata1 and the log files (when MySQL is shut doen), 
> will it destroy these databases?

yes

in general do *not* touch files maintained by a service


Attachment: [application/pgp-signature] OpenPGP digital signature signature.asc
Thread
Role of ibdata1 for DB with innodb_file_per_tableWiebe Cazemier12 Nov
  • Re: Role of ibdata1 for DB with innodb_file_per_tableReindl Harald12 Nov