Jump to content


Check out our Community Blogs

Register and join over 40,000 other developers!


Recent Status Updates

View All Updates

Photo
* * * * * 1 votes

Mounting a MYI, MYD and FRM Files

sql

This topic has been archived. This means that you cannot reply to this topic.
2 replies to this topic

#1 bentez

bentez

    CC Lurker

  • Just Joined
  • Pip
  • 2 posts

Posted 08 December 2015 - 11:29 AM

I received a database I need to restore on my local machine.  The database is MySQL off a Linux box, is it possible to mount these files similar to how you would a .mdb file on a MSSQL Server?  I am looking to mount them on my Windows based version of MySQL 5.5.

I have the MYI, MYD and FRM files.



#2 Lakatos

Lakatos

    CC Lurker

  • Just Joined
  • Pip
  • 1 posts

Posted 12 December 2015 - 10:45 AM

Assuming MyISAM tables (it looks like that based on the file extensions):

1.  Create the database i.e. "create database databasename"

2.  shut down mysql

3.  Go to the mysql data directory (you can do a "show variables like 'datadir'" to find this out before shutting down mysql)

4.  Load the files to the /path/to/datadir/databasename

5.  restart mysql

That should make the tables for that database accessible.  If that doesn't solve your issue then you can try MySql Recovery Toolbox.  The MySql recovery tool recovers databases in the MyISAM format and either saves the data to disk as SQL scripts or exports it directly to the MySQL server. http://www.oemailrec...l_recovery.html


See also http://stackoverflow...d-myi-frm-files

http://www.sqlserver...584-2893-1.aspx

some "gotchas" other people have encountered.



#3 bentez

bentez

    CC Lurker

  • Just Joined
  • Pip
  • 2 posts

Posted 14 December 2015 - 07:19 AM

I am very grateful for your advice. Thank you very much! The issue has been resolved.)





Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download