Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

Assuming I only have access to the raw files (.myd, .myi, .frm), would I simply copy+paste mysql db files obtained from /var/lib/mysql/mydb to C:\Program Files\MySQL\MySQL Workbench CE 5.2.47\data\mydb or is it C:\Program Files\MySQL\MySQL Server 5.6\data\mydb? I was using mysql-5.1.43 on Linux and now mysql 5.6 on Windows 7. I don't have access to the Linux anymore.

I have tried the top 2 Windows locations with no success. I cannot even tell where data is actually being kept when I create a new schema in Workbench; neither of the two locations have the actual data files for the new dummy schema I create, even after I post some data to the tables.

I don't seem to get any direct answer to my question on similar questions asked on this site.

Kindly help.

share|improve this question

closed as off topic by EEAA, Jenny D, Sven, mdpc, Ward Apr 18 '13 at 4:47

Questions on Server Fault are expected to relate to server, networking, or related infrastructure administration within the scope defined by the community. Consider editing the question or leaving comments for improvement if you believe the question can be reworded to fit within the scope. Read more about reopening questions here.If this question can be reworded to fit the rules in the help center, please edit the question.

1 Answer 1

up vote 0 down vote accepted

MyISAM data can indeed simply be copied from one MySQL instance to the next. If you don't know where to put the data, your running MySQL instance can tell you:

mysql> select @@datadir\G
*************************** 1. row ***************************
@@datadir: /srv/mysql/
1 row in set (0.00 sec)
share|improve this answer
    
Yes indeed I've found the path to the data through the command above. However, and I hope this will now nail it, the file extensions are different somewhat - i.e. instead of .opt, .myd, .myi, .frm I now see .opt, .ibd, .frm. How do I integrate the two? Do I simply (with MySQL being off) erase the new format files and copy the old data-laden format? –  EdNdee Apr 17 '13 at 17:16
    
Actually, I did as above (replaced the new with the old) and it's now fully functional. Thanks a lot! –  EdNdee Apr 17 '13 at 17:38

Not the answer you're looking for? Browse other questions tagged or ask your own question.