Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Accidentally Updated All Data Inside Table! Help!

forums › forums › SQLyog › Using SQLyog › Accidentally Updated All Data Inside Table! Help!

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • October 24, 2005 at 10:40 am #9311
      Det7
      Member

      Hi guys, I was doing an update on my application and I was using the live database itself while debugging. And I tried editing one of the activities there, and suddenly when I looked at the activities table.. all of the activities inside where edited!!!!

      Wahhh!! This is a not so big database as for corporate. Coz my application is for our team but there are a hundred records already and my last backup was around 40 records.. I'm kind of ashamed telling it to them. help guys helP!

      Is there a way where i can roll back the table info? Im using SQLyog…

    • October 24, 2005 at 12:15 pm #19578
      peterlaursen
      Participant

      Nope!

      But maybe you should learn about the 'Binary Log'? It is just like a tape recorder recording everything that happens to your database.

      If you had this one active with your database you could restore your latest backup and 'replay' the binary log from the point of time of the backup to the point of time where something went wrong.

      It is all in the MySQL documentation. They also published an article on it some 4-6 months ago. Must be in their archives.

    • October 25, 2005 at 7:05 am #19579
      Det7
      Member

      Anybody who was able to do this binary log stuff? Im using MySQL 4.3.. help..

  • Author
    Posts
Viewing 2 reply threads
  • You must be logged in to reply to this topic.