Clear Database files

boostedvtak2 years ago

Hello guys, I've got a traccar running up on a VPS, looks like it's run out of space. I've seen the documentation post for clearing the history, which involves creating a cronjob, I created the cronjob, made it executable a while ago, thought it was running but I guess not...
So as a test, I ran it as itself, and it fails on line 4:

./traccar-clear-database: line 4: mysql: command not found

I installed it using the traccar.run file in the linux downloads, I'd assumed this would install mysql/mariadb or something similar, however, running the mysql -u root -p command, seems to tell me to install mysql...

I'm a bit stumped now, any ideas of what database it is using, and how I could set things older than a certain amount of days to be cleared?

Thank you in advanced.

Anton Tananaev2 years ago

Traccar does not install MySQL for you automatically. B default it uses the embedded database (H2).

boostedvtak2 years ago

Thanks for the info. I've now got it running from a MySQL DB, using the InnoDB engine, and got the cronjob working.

You are a legend!