Thursday, December 8, 2016

mysql - innodb files in wrong directory

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 ?

No comments:

Post a Comment

linux - How to SSH to ec2 instance in VPC private subnet via NAT server

I have created a VPC in aws with a public subnet and a private subnet. The private subnet does not have direct access to external network. S...