Solved

Received Zip file of .myd and .myi files/tables, Is there an easy way to add these to a database?

Posted on 2004-03-24
5
802 Views
Last Modified: 2008-03-04
I have received a set of .myd and .myi files/tables.  I have no idea of their structure.  Is there any way to add them to a database or import them to a MySQL database?  If I drop them in a database directory they are not visible in MySQL CC.
0
Comment
Question by:swheitz
  • 2
5 Comments
 
LVL 17

Expert Comment

by:Squeebee
ID: 10669944
Do you have .frm files as well? .MYI and .MYD are essentially useless without .FRM files.
0
 

Author Comment

by:swheitz
ID: 10669998
No I don't have .frm files.  Is it possible that older versions of MySQL did not use .frm files?
0
 
LVL 17

Accepted Solution

by:
Squeebee earned 500 total points
ID: 10670540
.FRM files are as old as .MYI and .MYD

If you had the exact CREATE TABLE statements used on each table we could recreate the .FRM files.
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

As a database administrator, you may need to audit your table(s) to determine whether the data types are optimal for your real-world data needs.  This Article is intended to be a resource for such a task. Preface The other day, I was involved …
Password hashing is better than message digests or encryption, and you should be using it instead of message digests or encryption.  Find out why and how in this article, which supplements the original article on PHP Client Registration, Login, Logo…
This video discusses moving either the default database or any database to a new volume.
Excel styles will make formatting consistent and let you apply and change formatting faster. In this tutorial, you'll learn how to use Excel's built-in styles, how to modify styles, and how to create your own. You'll also learn how to use your custo…

746 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

16 Experts available now in Live!

Get 1:1 Help Now