• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 592
  • 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
Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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