MySQL Database Error - Lost files recovered
Posted on 2011-03-09
I came in to the office yesterday to find that all data in the Data directory on our Mac servers has 'disappeared'.
Since today I've been trying to recover from old scripts we dumped a while ago but the data is so old it's useless.
Anyway, today I used some file recovery software on the mac and found all the files. I've got the now, all the FRM and MYD and a huge ibdata1 and two log files. When I had the issue I installed MySQL 5.5 on to the server, I know, you do things in panic, no idea why....but I have the files in the new data directory on the Mac.
If I go in to Navicat I can see all the table references and all the views etc for the database but when I try to open them it says that the table cannot be found.
Is there something I need to do to 'activate' the new data in the directory?
I also installed a new MySQL server on our windows machine and I'm trying to copy the same Data directory to that to see if it's something to do with permissions as I had to give 'everyone' permission so I could copy the directory.
Sorry if this all sounds a little frantic but ... I am.
Any help would be greatly appreciated!