I have created a database called TEST with innodb tables. When I look in the /var/lib/mysql/TEST directory I see a .frm file for each table. However, there are no .ibd files in that directory. The only ibd file I can find is /var/lib/mysql/ibdata1

Should there be at least one ibd file in the /var/lib/mysql/TEST directory? Why is the ibdata1 file not in /TEST ?


default behavior is all in one, if you looking to separate it you need to read following:

MySQL :: MySQL 5.6 Reference Manual :: 14.5.2 InnoDB File-Per-Table Mode

  • My primary issue is why is the file not in the TEST subdirectory? (I realize that settings creates one file per table) – TSG Mar 9 '15 at 21:55
  • That is the way InnoDB works. All tables on all databases are in the ibdataX -files in /var/lib/mysql by default. – Tero Kilkanen Mar 10 '15 at 6:03

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.