Restore MySQL from raw data
jared
College Station, TX Icrontian
Alright, I have a question for any of you server admins - particularly who deal with IIS (i know, I know)
A buddy of mine and I co-manage a Windows server (Actually, he does most of it, I just make websites that go on it ).
The HD decided to take a dive on us the other day, forcing us to swap out drives, get the install back up to par, and load the backups.
Luckily, we had back ups of all the clients' files. Well, almost.
Some how none of the MySQL data had been dumped during the scheduled backups.
So, after repeated *facepalm*'s we realize we don't have a
good backup of the databases but we do have the complete mySQL 5 directory including the data files. However, I can't seem to find any information about restoring the databases using the raw files.
Any pointers?
cheers
A buddy of mine and I co-manage a Windows server (Actually, he does most of it, I just make websites that go on it ).
The HD decided to take a dive on us the other day, forcing us to swap out drives, get the install back up to par, and load the backups.
Luckily, we had back ups of all the clients' files. Well, almost.
Some how none of the MySQL data had been dumped during the scheduled backups.
So, after repeated *facepalm*'s we realize we don't have a
good backup of the databases but we do have the complete mySQL 5 directory including the data files. However, I can't seem to find any information about restoring the databases using the raw files.
Any pointers?
cheers
0
Comments
Something along the lines of "fire up mysql, create a DB" and "copy the .myi and .myd files over there".
I'll see what kinda trouble I can get into.
Then load it into the new DB fresh. This allows you to correct errors, move to the latest stable version and control data integrity