Any modern way to "save" deleted rows to prevent accidental data loss? (MySQL + Javascript)

Birdie1 — Wed, 27 Jan 2021 13:48:38 GMT

Hi,

I am building a project that relies on data that arrives from the internet, thing is there can be modifications in which case I need to delete rows.

This is done automatically by a script, but I want to prevent a case in which all the data is deleted.

I have a few mechanisms to prevent it from happening, but still the fact I have a line that says "Delete everything that is not in this array" scares me.

Is there a way to save those deleted rows somewhere? I saw on stack overflow a solution from 2010 to either create a new table to store deleted rows or add a collum to see if active/inactive, but then I need to modify all the queries to handle it.

Or maybe my best bet is to just create a backup of the table before executing the update method?

Re: Any modern way to "save" deleted rows to prevent accidental data loss? (MySQL + Javasc

keveinleo — Thu, 15 Apr 2021 15:53:08 GMT

If you add a trigger to save the data in a separate table you do not need to change your application code. You can also check this site.

topic Any modern way to "save" deleted rows to prevent accidental data loss? (MySQL + Javascript) in Integration and Testing

Any modern way to "save" deleted rows to prevent accidental data loss? (MySQL + Javascript)

Re: Any modern way to "save" deleted rows to prevent accidental data loss? (MySQL + Javasc