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
cereal 1,524 Nearly a Senior Poster Featured Poster
Hi,
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 would need mysql.func and mysql.proc contents.
Try to follow the suggestions in this thread, it could help:
diafol commented: good points +15
diafol
Discussion: 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 you have MyISAM tables if you do ot have ibdata files?
KristofLakatos 0 Newbie Poster
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.oemailrecovery.com/mysql_recovery.html
KristofLakatos 0 Newbie Poster
See also http://stackoverflow.com/questions/879176/how-to-recover-mysql-db-from-myd-myi-frm-files
http://www.sqlservercentral.com/Forums/Topic1619584-2893-1.aspx
Some "gotchas" other people have encountered.
jaime.bentez 0 Newbie Poster
Thank you all for your advice! The issue has been resolved.
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.