Ask your database administrator about PITR (Point In Time Recovery).
On 8/10/23 04:17, Rajesh Kumar wrote:
In that case, how to take a backup specifically before that update and are there any prequisites such as stopping the server when it happens? And then backup like that?
I'm afraid you will have to execute the SQL statement undoing it. Of you don't know the previous values, you're out of luck.
Then a backup is your best friend.
Hi friends
I was given a query to update the record in table A with where clause. But I executed it in production mistakenly without where clause so it updated incorrectly for all rows.
How do I resolve this?
--
Born in Arizona, moved to Babylonia.
