472,144 Members | 1,959 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,144 software developers and data experts.

Database Restore / MySQL 4.1 -- InnoDB


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?!


May 1 '06 #1
0 1470

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

23 posts views Thread by ajikoe | last post: by
reply views Thread by Terry | last post: by
39 posts views Thread by Mairhtin O'Feannag | last post: by
5 posts views Thread by patrick | last post: by
33 posts views Thread by bill | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.