MySQL Forums
Forum List  »  Security

Re: How to unrecoverable data deletion
Posted by: Peter Brawley
Date: August 18, 2020 09:22PM

> Users are asking for permanent data deletion that cannot be recovered.

If the binary log is enabled, eg for replication, deletions can be recovered by restoring from a backup then replaying the binary log.

Restoring from a previous backup will restore deleted data. The only way round that is to destroy the backups ... then of course crash recovery will be impossible.

Users who want their data to disappear forever need not to put such data in a database that depends on logs and backups for data integrity.

Options: ReplyQuote


Subject
Views
Written By
Posted
Re: How to unrecoverable data deletion
139
August 18, 2020 09:22PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.