Re: Undo Update

Ron <ronljohnsonjr@xxxxxxxxx> · Thu, 10 Aug 2023 10:08:51 -0500



    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?
      

        On Thu, 10 Aug, 2023, 2:36 PM
          Holger Jakobs, <holger@xxxxxxxxxx>
          wrote:

        
            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.
            

              Am 10. August 2023 11:02:26 MESZ schrieb
                Rajesh Kumar <rajeshkumar.dba09@xxxxxxxxx>:
              
                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.