I have the .frm
and .ibd
files from an old, non-working MySQL server (on Windows). I took out the hard drive and was able to get the data directory copied to my machine.
How would I get them into MySQL on my development machine? I tried just copying the directory into the MySQL data directory, but that didn't work.
The old database is v5.5.4, and my version is v5.7.15. I'd be happy to install a matching MySQL version if that would help.
I saw Restoring MySQL Tables from .ibd, .frm and mysqllogbin filesRestoring MySQL Tables from .ibd, .frm and mysqllogbin files, but this database has over 800 tables in it - way too much for that process.