Mysql DB Restore

Databases
1

Hi All,

Unfortunately, we have updated 1000 records in mysql db 2 days back. Is it possible to revert back the data before updating 1000 records?

Please let me know.

OS: Suse Linux
Mysql: 5.0

Thanks,
Vinay

2

only if you have a backup, or if the update is algorithmic

for instance, if you did this –

UPDATE daTable
   SET somecolumn = somecolumn + 937
 WHERE someothercolumn = 'somevalue'

then you can back out these changes by doing this ----

UPDATE daTable
   SET somecolumn = somecolumn - 937
 WHERE someothercolumn = 'somevalue'

otherwise you are s.o.l.