|
|||||||
| Forums | Search Forums | Register | Forum Rules | Man Pages | Albums | FAQ | Members | Calendar | Search | Today's Posts | Mark Forums Read |
| 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. |
|
|
|
Thread Tools | Search this Thread | Display Modes |
|
#1
|
|||
|
|||
|
[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
|
||||
|
||||
|
Would you mind to share the solution?
|
| Sponsored Links | ||
|
|
#3
|
|||
|
|||
|
lol, I found a off-site backup!
|
|
#4
|
|||
|
|||
|
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
|
||||
|
||||
|
Quote:
|
| Sponsored Links | |
|
|
#6
|
|||
|
|||
|
Whoops, my bad.
Yes, before you run a commit. |
| Sponsored Links | |
|
|
#7
|
|||
|
|||
|
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 | ||
|
![]() |
| Thread Tools | Search this Thread |
| 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 |
|
|