I think your idea should work, but you definitely should create those indexes.
Why dont you backup the whole database ? I use phpmyadmin for it. It is very easy to use with its web interface to backup anything you need.
Hi Track-trace
Thank you for your suggestions
I just need to preserve history for 90 days so after de first backup I will delete anything beyond 90 days. After that I plan to do a daily full backup with a 90 day sliding window.
phpmyadmin is a very good tip, I will give it a try
Hi Anton
Thank you for your answer
Amado I believe using the rest API you could make a DELETE request to positions endpoint and delete all the positions within a timestamp.
You could possibly come up with a web script instead of playing around your database.
Hello. I'm running traccar 5.8 with mysql db. About 300 reporting devices
I need a strategy to backup the last 90 days of events and positions. I have some ideas and I would like to hear comments/suggestions: