Re:Flickr Accidentally Deletes a User's 4,000 Photos and Can...
by hrktb on Wednesday February 02, 2011 @02:10AM
(#2169418)
Reverting a full db should be straightforward (stop the db server and revert a dump).
For a single account it's more of a pita.
Retrieving all the datas associated with one account, put it in a format readable from the production environment and recommit all the changes while dealing with the potential errors and inconstencies seems quite a huge deal.
Messing unrelated data in the process would also be a nightmare.
Of course, not deleting anything from the start wouod be the way.
Re:Flickr Accidentally Deletes a User's 4,000 Photos and Can...
by gaius on Wednesday February 02, 2011 @06:19AM
(#2169848)
It's trivial in Oracle, just do a Flashback Query. You would just need to support that in whatever front end interface the customer support people use.
For a single account it's more of a pita.
Retrieving all the datas associated with one account, put it in a format readable from the production environment and recommit all the changes while dealing with the potential errors and inconstencies seems quite a huge deal.
Messing unrelated data in the process would also be a nightmare.
Of course, not deleting anything from the start wouod be the way.