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