search

vitalidze / traccar-web

Traccar Web UI mod
http://traccar.litvak.su/
152 stars 145 forks source link

Compact or clean database #1218

Closed ghost closed 5 years ago

ghost commented 5 years ago

Hello,

My mysql database is 9Go !!! How to clean or compact it please ?

regards. Igor

vitalidze commented 5 years ago

You need to:

  1. delete excessive data (positions, events)
  2. dump your DB with mysqldump
  3. depending on your MySQL config either wipe your entire MySQL data folder or just drop your existing DB

I would recommend to just clean up the data in 1 and don't do any additional steps. Then you have to periodically do such clean ups.