Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Functionality to save and restore database state

I would like to create a functionality in my program to save current database state and be able to restore it in future. I would also like to be able, if I go back to some state from, let's say 2 days ago, to return to a state from today. I was thinking about restoring a database from a transaction log (everytime I want to save the state I commit a mareked transaction (on some insignificant data)). Is it possible at all, using this solution to restore some earlier state and after that be able to restore a more recent state, or would I lost it after the restore (or they would disappear form transaction log)?

like image 466
matt99 Avatar asked Oct 17 '25 15:10

matt99


1 Answers

Database snapshots ?

like image 56
ceth Avatar answered Oct 20 '25 07:10

ceth



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!