Is there a way to set a MySQL database back to everything it had in it a moment before something was changed? Say, 25 minutes ago?

Nuff Sed2021-01-23T15:41:59Z

Yes, you load the backup that you did 30 minutes ago, otherwise, no.

Anonymous2021-01-22T18:35:53Z

Alas, you have to arrange that ahead of time, before the event. You will need a snapshot of the database at a point in time, and a log of all the changes that were made after that so it can be played back to re-create the current state. Find out if your database has that kind of backup and logging set up.

Sandeep2021-01-22T07:32:17Z

No, that's the reason we take backups.

P2021-01-19T20:58:29Z

The short answer is no, unless you setup automated SQL backups to run every 30 minutes, however the fact you are asking probably means you did not.  

Anonymous2021-01-19T20:15:59Z

Is it backed up?

Show more answers (2)