I could really use some help here. I have the contents of a database from a server that died, and I need to restore it on our new server. I have the following files from the old mysql folder:
as well as the files in the sub mysql/ folder:
I tried transferring the ib_ files to the new mysql folder, and nothing seems to break. However, when I transfer any of the .MYI,.MYD, or .frm files then mysql refuses to start up properly. The old db was MySQL 4, and the new one is MySQL 5 - is it possible to restore 4 data to 5?
If anyone could give me tips on what exactly to do to get things working it would be much appreciated.