• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 782
  • Last Modified:

MySQL FRM Files

I noticed something strange on one of my databases today.  In the folder that stores table names/data (bin\mysql\mysql5.1.36\data\tablename), I only have .frm files.  The database works fine, but this folder does not contain .myd or .myi files.  How can I be missing those two file types and still see all of my data?
0
thedeal56
Asked:
thedeal56
1 Solution
 
larsrohrCommented:
InnoDB tables, perhaps?
MyISAM tables use .myd and .myi files, but InnoDB tables don't.
0
 
thedeal56Author Commented:
Yep that's it thanks
0

Featured Post

[Webinar] Cloud and Mobile-First Strategy

Maybe you’ve fully adopted the cloud since the beginning. Or maybe you started with on-prem resources but are pursuing a “cloud and mobile first” strategy. Getting to that end state has its challenges. Discover how to build out a 100% cloud and mobile IT strategy in this webinar.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now