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 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.