Backup mysql database last month

Jose mancilla ortega 2 years ago

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 Tananaev 2 years ago

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

Jose mancilla ortega 2 years ago

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 Tananaev 2 years ago

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