Backup mysql database last month

I hope everyone is fine, I have a database of around 100 GB used in the tc_positions table since the console does not allow me to delete previous records.
Before to delete records I used the following script

DELETE FROM tc_positions where servertime < DATE(NOW() - INTERVAL 90 day);
DELETE FROM tc_events where servertime < DATE(NOW() - INTERVAL 90 day);

At one point it didn't let me delete any more records.

At this time I have only backed up the database without the tc_positions and tc_events tables

mysqldump -u userbd -p --ignore-table=traccarcero.tc_positions --ignore-table=traccarcero.tc_events traccarcero > backup.sql

I would like to know if it is possible to backup the database and in the tc_positions and tc_events tables to backup the most recent 30 days

Anton Tananaeva year ago

Should be possible. You just need to pass the right parameters to mysqldump.

I see that you have a professional services section (paid service) I would like to know if it is possible for you to send me the sentence with the mysqldump conditions

Anton Tananaeva year ago

Yes, if you're interested in paid service, please email support.