> It might not be appropriate for you, but a good way to handle MySQL backups is to maintain a mirror.
DELETE * FROM business_critical_data; WHERE obsolete = true;
You were saying? :D