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
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
Yes, if you're interested in paid service, please email support.
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
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
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