By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
432,109 Members | 932 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 432,109 IT Pros & Developers. It's quick & easy.

.mdb file on a MSSQL Server

P: 3
Today I brought the database I need to restore. I'll be doing it on your local computer.
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.
Sep 11 '16 #1

✓ answered by RonanODriscoll

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 database recovery tool like MySql Recovery Toolbox 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
Some "gotchas" other people have encountered.

Share this Question
Share on Google+
3 Replies


P: 3
Any help would be appreciated!)
Sep 12 '16 #2

RonanODriscoll
P: 3
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 database recovery tool like MySql Recovery Toolbox 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
Some "gotchas" other people have encountered.
Sep 12 '16 #3

P: 3
Thanks for the useful information!
Sep 13 '16 #4

Post your reply

Sign in to post your reply or Sign up for a free account.