Maintenance

Database Maintenance

-- Cleanup old positions
DELETE FROM positions 
WHERE serverTime < NOW() - INTERVAL 30 DAY;
-- Optimize tables
OPTIMIZE TABLE positions;
OPTIMIZE TABLE events;

System Cleanup

# Clean logs
find /opt/traccar/logs -name "*.log" -mtime +30 -delete
# Backup configuration
cp /opt/traccar/conf/traccar.xml /backup/
# Archive data
mysqldump -u traccar -p traccar > traccar_backup.sql