1

Possible Duplicate:
How to undo a query execution in phpmyadmin

I have a stupid mistake. It cause by I'm very sleepy.

Actually i want to update some date from B table, but I mistype for that query. I type A table so all of data inside A table is changed. I'm using Phpmyadmin.

I'm very panic for now. Could anyone give me some suggestion for this case?


the data are not deleted but the date is changed.

Community
  • 1
  • 1
nunu
  • 2,703
  • 9
  • 33
  • 55

1 Answers1

4

There is no way to undo a query. If the query was something like UPDATE a SET x = x + 1, you could reverse it with UPDATE a SET x = x - 1, but other than that, you cannot revert queries. The best thing you can do is restoring a backup you've made before.

Lekensteyn
  • 64,486
  • 22
  • 159
  • 192
  • I have each month back up how to replace that data? because I set my table cant duplicate. – nunu Oct 29 '11 at 09:50
  • @nunu: you can restore the subject table from your backup to a second database/table and try to recover data in that way. I don't know enough about your situation to guide you further, sorry. – Lekensteyn Oct 29 '11 at 09:52