I have a table that is not too much big but still, it takes 30GB of storage.
When I try to make a backup with mysqldump it takes a lot of time and resources and I want to optimize it but I don't know how.
My data is based on the date. I never delete or change the old data except for sometimes that I make changes to one field that is not too important to be in everyday backup (maybe one weekly backup)
How I can change my backup process to only make a backup of the new data (for example only backup data from today)?
One of my solutions is to make a separate table for every 3 months and make daily backup only for the main table. But it make my application very complicated.
Should I create separate tables for archive? Or is there any better solution?