Logs 90 days

tracker 3 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 Tananaev 3 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.

tracker 3 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 Tananaev 3 years ago

I think you forgot to ask your question.

tracker 3 years ago

Where do I put these parameters

Anton Tananaev 3 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.

tracker 3 years ago

I selected the traccar database and pasted the commands.