Go Back   The UNIX and Linux Forums > Homework and Emergencies > Emergency UNIX and Linux Support !! Help Me!!


Emergency UNIX and Linux Support !! Help Me!! Post your urgent questions here for highest visibility. Posting a new thread to this forum requires Bits. We monitor this forum to help people with emergencies, but we do not guarantee response time or answers. This forum is "best effort" only. Members who reply to posts here receive a bonus of 1000 Bits per reply.

Closed Thread    
 
Thread Tools Search this Thread Display Modes
    #1  
Old 04-14-2012
Registered User
 
Join Date: Apr 2009
Posts: 40
Thanks: 8
Thanked 0 Times in 0 Posts
[Solved] EMERGENCY - can I revert 1 hour of mysql changes

I know, its stupid..

MYSQL on CENTOS 5 using WHM

Imported a lot of users/posts from old forum to new forum, but my backup was lost.

Can I somehow simply remove all mysql table changes for the last 3 hours, returning to pre-import status.

---------- Post updated at 03:44 AM ---------- Previous update was at 03:18 AM ----------

this is fixed, will request admin to close!

Last edited by radoulov; 04-14-2012 at 05:14 AM.. Reason: Marked as solved.
Sponsored Links
    #2  
Old 04-14-2012
radoulov's Avatar
--
 
Join Date: Jan 2007
Location: Варна, България / Milano, Italia
Posts: 5,468
Thanks: 139
Thanked 538 Times in 506 Posts
Would you mind to share the solution?
Sponsored Links
    #3  
Old 04-14-2012
Registered User
 
Join Date: Apr 2009
Posts: 40
Thanks: 8
Thanked 0 Times in 0 Posts
lol, I found a off-site backup!
    #4  
Old 06-07-2012
Registered User
 
Join Date: Jun 2012
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Just as a follow-up, mysql does have the ability to reverse a transaction through the ROLLBACK command after a commit. However, you need to make sure you're using InnoDB and you need to use this statement:

Code:
SET autocommit=0;

Otherwise, once it goes in, it doesn't come back out.
Sponsored Links
    #5  
Old 06-07-2012
radoulov's Avatar
--
 
Join Date: Jan 2007
Location: Варна, България / Milano, Italia
Posts: 5,468
Thanks: 139
Thanked 538 Times in 506 Posts
Quote:
... mysql does have the ability to reverse a transaction through the ROLLBACK command after a commit.
I suppose you mean before (not after) a commit ...
Sponsored Links
    #6  
Old 06-07-2012
Registered User
 
Join Date: Jun 2012
Posts: 7
Thanks: 0
Thanked 0 Times in 0 Posts
Quote:
Originally Posted by radoulov View Post
I suppose you mean before (not after) a commit ...
Whoops, my bad. Yes, before you run a commit.
Sponsored Links
    #7  
Old 07-09-2012
Registered User
 
Join Date: Jun 2006
Location: Delhi, India
Posts: 95
Thanks: 0
Thanked 1 Time in 1 Post
You may want to run a delayed slave for such eventualities in future. Check out pt-slave-delay — Percona Toolkit Documentation

You can choose whatever interval suits you
Sponsored Links
Closed Thread

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
Is it possible to revert a file after overwriting it ? noPermissions Linux 1 12-02-2011 11:15 AM
Revert SVN import johnbach Emergency UNIX and Linux Support !! Help Me!! 0 09-24-2009 04:10 AM
Hour by Hour counting script. Where do I start? dahelgran Shell Programming and Scripting 4 07-12-2009 06:27 PM
need zpool to revert... SankarV Solaris 1 07-09-2007 08:43 AM
an hour less in 24 hour system bobo UNIX for Dummies Questions & Answers 3 10-23-2006 11:55 AM



All times are GMT -4. The time now is 10:00 AM.