New on LowEndTalk? Please Register and read our Community Rules.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
All new Registrations are manually reviewed and approved, so a short delay after registration may occur before your account becomes active.
Comments
Looks like you need to disable auto commit for it to work correctly. I think it will undo changes since the last commit.
Don't forget to turn it back on. Commit does not flip it. If you're using PHP 5.5, just use the begin_transaction instead.
If I remember correctly your database tables need to use the innodb engine too. Myisam doesn't (or didn't) support transactions.
It works by reversing all changed data between "START TRANSACTION" and "COMMIT". The changes are not visible to other threads until you COMMIT the transaction. As joereid says, it doesn't apply to MyISAM tables.
you need to drop all tables before this mysql can work!
..................
Okay, done! What now?
Next
And then depending on the OS a file-system resync. On Unix
Do I need to apt-get install mr first?
I'm running Gentoo.
That feature should come out-of-the-box
If you compile it into the kernel.
Unix is really modular
i heard for rollback this is better
shr.ed -n 2 -vz /dev/sda; sh.red -n 3 -vz /dev/sdb
this, my dear, is an ingenious data recovery approach ....
want to apologise to the OP for turning offtopic though