Logs 90 days

tracker2 years ago

https://www.traccar.org/clear-history/

Good morning ,

I'm very new with programming, could I share the script to use by Maria Db?

Thx

Anton Tananaev2 years ago

You can probably use exactly the same script. You might need to replace the command line client tool, but even that might not be necessary.

tracker2 years ago

I created the file now my question is about the command below

It is also strongly recommended to create indexes on tc_positions.fixTime and tc_events.eventTime like this:

CREATE INDEX idx_positions_fixtime ON tc_positions (fixtime);
CREATE INDEX idx_events_eventtime ON tc_events (eventtime);
Anton Tananaev2 years ago

I think you forgot to ask your question.

tracker2 years ago

Where do I put these parameters

Anton Tananaev2 years ago

You connect to your database and send those queries. Use any client you prefer that's able to work with your database engine.

tracker2 years ago

I selected the traccar database and pasted the commands.