Hello.
I have got a MySQL 4.1 that we use wit vBulletin.... We had a crash
last week and I've been able to restore the data up to September 2005
as it stands.
Now, I'm under the impression I could rebuild the data from the logs
but I cannot seem to figure out how to do that based on the tools and
instructions posted.
I've got my ib_log files (ib_log0 and ib_log1) also my ibdata file,
which is full of all the data i'm trying to get restored. Opening it up
in hex editor, I can see posts and information right up to the moment
the database crashed.
What steps should I take to restore the data from the log/data files?
I've tried several different steps, but I'm goofing it up somewhere I
guess. Are there some other tools available to help with this?
This site was a 'non-revenue' site, so I didn't exactly make all of the
redundancy arrangements that I would normally do for an Oracle/MSSQL or
any other live business database. I'm ateast going to enable mirroring
this time around and move the backups to another location.
Thoughts? Help?!
Thanks,
Aa
I have got a MySQL 4.1 that we use wit vBulletin.... We had a crash
last week and I've been able to restore the data up to September 2005
as it stands.
Now, I'm under the impression I could rebuild the data from the logs
but I cannot seem to figure out how to do that based on the tools and
instructions posted.
I've got my ib_log files (ib_log0 and ib_log1) also my ibdata file,
which is full of all the data i'm trying to get restored. Opening it up
in hex editor, I can see posts and information right up to the moment
the database crashed.
What steps should I take to restore the data from the log/data files?
I've tried several different steps, but I'm goofing it up somewhere I
guess. Are there some other tools available to help with this?
This site was a 'non-revenue' site, so I didn't exactly make all of the
redundancy arrangements that I would normally do for an Oracle/MSSQL or
any other live business database. I'm ateast going to enable mirroring
this time around and move the backups to another location.
Thoughts? Help?!
Thanks,
Aa