List:General Discussion« Previous MessageNext Message »
From:Christian Mack Date:April 20 1999 12:18pm
Subject:Re: help! restoring
View as plain text  
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

Thread
help! restoringpete collins19 Apr
  • Re: help! restoringChristian Mack20 Apr
    • Is there a way to know if It's a number?Jochen Haeberle20 Apr
      • Is there a way to know if It's a number?Michael Widenius21 Apr
        • Re: Is there a way to know if It's a number?Paul DuBois21 Apr
  • Re: Is there a way to know if It's a number?Benjamin Scherrey21 Apr
    • Re: Is there a way to know if It's a number?Thimble Smith21 Apr
  • Re: Is there a way to know if It's a number?Fred Read21 Apr
Re: Is there a way to know if It's a number?Christopher R. Jones21 Apr
  • Re: Is there a way to know if It's a number?Graham Ashton22 Apr