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.
jaime.bentez
0
Newbie Poster
Recommended Answers
Jump to PostHi,
best solution would be to get data through mysqldump and then push the backup into the server. By the way, if there were InnoDB tables then you also need ibdata files otherwise moving the files will not work. Also if there were user defined functions and stored procedures you …
Jump to PostDiscussion: http://stackoverflow.com/questions/879176/how-to-recover-mysql-db-from-myd-myi-frm-files
I'd second cereal's suggestion of an sql dump. This can take some time for BIG data, but if you're restoring on local machine, it should be reasonably straightforward. I am assuming …
All 5 Replies
cereal
1,524
Nearly a Senior Poster
Featured Poster
diafol
commented:
good points
+15
diafol
KristofLakatos
0
Newbie Poster
KristofLakatos
0
Newbie Poster
jaime.bentez
0
Newbie Poster
Be a part of the DaniWeb community
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.