0

I have .FRM, .MYD and .MYI files from a MySQL (version 3.23 I think) database from back in the early 2000's. I managed to get the files into a Windows installation of 3.23 and then dump it, however I can't get it into a version 4.0 installation. I've been trying to migrate it from one version to another to another, however every step causes another issue, whether with the installation of an old version, or changes in reserved words, etc.

Is there anything out there to simplify this process? Any thoughts on how I can bring the data files to current compatibility? My end goal is to get it all into a PostgreSQL database.

To reiterate, all I have are the data files and only MYD, MYI, FRM. I don't actually have a working installation from which to run queries. Even the Windows install I managed to get up and running seemed to pose challenges.

0

You managed to dump it? Using what? Perhaps a 3.23 version of mysqldump? If so, that is a text file that contains CREATEs and INSERTs. There is at least one incompatibility that it may have: TYPE=MyISAM -- In some version, TYPE was replaced by ENGINE.

You say "can't get it into 4.0" -- Does that mean you have a 4.0 and the load fails? With what error?

If you have a 5.x version, and you have the output from mysqldump, then you should be able to load it (except for TYPE/ENGINE).

  • After a lot of tinkering, I was able to get the windows version to serve up the old tables by just putting the tables into the data directory, and then I was able to load into a CSV file. I decided not to mess with mysqldump and then trying to migrate from one version to another and deal with the incompatibilities. My colleague was also able to export into json, so we're going to work with it in that format. – Brooks Apr 17 '15 at 3:43
  • Good. But JSON?? Nothing in MySQL (until 5.7) deals with JSON. – Rick James Apr 17 '15 at 3:47
  • I decided to use Postgresql on AWS. I'll likely use the csv export to import the data, but we're going to make as many backups in as many formats as possible before doing away with the old mysql.... – Brooks Apr 17 '15 at 3:50

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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