Skip to main content
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
Bumped by Community user
replaced http://dba.stackexchange.com/ with https://dba.stackexchange.com/
Source Link

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.

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 files, but this database has over 800 tables in it - way too much for that process.

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 files, but this database has over 800 tables in it - way too much for that process.

Incorporated comment; removed meta content; improved formatting and title
Source Link
Paul White
  • 90.3k
  • 30
  • 424
  • 663

How do I import Import .frm and .ibd files into a new instance of MySQL?

I have the .frm and .ibd files from an old, non-working mysqlMySQL server (windowson Windows). I took out the hard drive and was able to get the data directory copied to my machine. How

How would I get them into MySQL on my development machine? II 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.

(edited for clarity) thanks I saw Restoring MySQL Tables from .ibd, .frm and mysqllogbin files, ghbut this database has over 800 tables in it - way too much for that process.

How do I import .frm and .ibd files into a new instance of MySQL?

I have the .frm and .ibd files from an old, non-working mysql server (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.

(edited for clarity) thanks, gh

Import .frm and .ibd files into a new instance of MySQL

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 files, but this database has over 800 tables in it - way too much for that process.

deleted 329 characters in body
Source Link
user113329
user113329

My company recently purchased an asset that uses a particular maintenance program with a MySQL backend. That company no longer exists, and I wish to import the records into a maintenance program I wrote. I took out the hard drive, copied the data directory to my system, and now I need to import the schema into my MySQL instance, in order to later export it to a SQL Server database.

Now that I have the .frm and .ibd files from an old, hownon-working mysql server (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.

(edited for clarity) thanks, gh

My company recently purchased an asset that uses a particular maintenance program with a MySQL backend. That company no longer exists, and I wish to import the records into a maintenance program I wrote. I took out the hard drive, copied the data directory to my system, and now I need to import the schema into my MySQL instance, in order to later export it to a SQL Server database.

Now that I have the .frm and .ibd files, how would I get them into MySQL? I tried just copying the 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 have the .frm and .ibd files from an old, non-working mysql server (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.

(edited for clarity) thanks, gh

rephrased the question
Source Link
mustaccio
  • 26.9k
  • 24
  • 58
  • 74
Loading
Source Link
user113329
user113329
Loading