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!
Would you mind to share the solution?
lol, I found a off-site backup!
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:
SET autocommit=0;
Otherwise, once it goes in, it doesn't come back out.
I suppose you mean before (not after) a commit ...
Whoops, my bad. :o Yes, before you run a commit.
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