Re: help! restoring

[Christian Mack]

pete collins wrote:
> 
> ok i'm having trouble with the tape  backed i made this moring :-(
> 
> question is there any way to restore a database from a few hours ago?
> other
> than tape
> 
> mysql has not been restarted or flushed (or dumped) since  :-(
> only a few changes have been made
> 
> can i undo the change that was made earlier by another user that screwed
> up the tables?
> 
> any help would be greatly appreciated
> 
> thanks
> 
> pete

Hi Pete

With the update-log you can restore your database (if you generated it).
Restore the last backup.
Delete the SQL command in the update log that screwed up your DB.
Run the update log on your old (restored) DB.

Tschau
Christian