[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 553
  • Last Modified:

How do you open a MySQL .frm file

I was given some FRM files to open, but they do not have matching MYD files.  Is there any way that I can open them?  They're not even visible in PHP MyADMIN.  Thanks.
0
ssailer
Asked:
ssailer
  • 5
  • 5
1 Solution
 
Dave BaldwinFixer of ProblemsCommented:
That doesn't make any sense.  The FRM files just contain some info about the table organization of the MYD and maybe the MYI files.  The FRM files on my computer are mostly 0's.
0
 
ssailerAuthor Commented:
This is all they sent to me.  There are no matching MYD files.  So ... maybe they can't be opened because they are essentially incomplete?
0
 
Dave BaldwinFixer of ProblemsCommented:
The FRM file does not contain any of the data from the table.  The MYD files contain the data and I believe the MYI files contain the indexes.
0
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
ssailerAuthor Commented:
Yes ... correct.  I wasn't sure if there was any way to open the FRM file without the matching MYD file.  Guess not.  :(
0
 
Dave BaldwinFixer of ProblemsCommented:
It's just a binary file.  I looked at it with a program called Filealyzer http://www.safer-networking.org/products/filealyzer/ which will let you view a hex dump of the file contents.
0
 
ssailerAuthor Commented:
But it's not going to allow me to view any real data, right?
0
 
Dave BaldwinFixer of ProblemsCommented:
No, because there isn't any real data there.  I can see the names of the columns in the FRM but not much more.  All of the data is in the MYD file.
0
 
ssailerAuthor Commented:
Alright ... kind of what I thought - too bad.
0
 
ssailerAuthor Commented:
My question was answered, but there was no solution to my question.  Not the responder's fault ... it just couldn't be done.
0
 
Dave BaldwinFixer of ProblemsCommented:
Thanks for the points.
0

Featured Post

NEW Veeam Agent for Microsoft Windows

Backup and recover physical and cloud-based servers and workstations, as well as endpoint devices that belong to remote users. Avoid downtime and data loss quickly and easily for Windows-based physical or public cloud-based workloads!

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