New clear/dbspots command for MySQL/MariaDB spot cleanup - MOJO
Hi, For those using MySQL/MariaDB as the native backend to store DXSpider spots and who want to remove old spot records, I have created a new command called: clear/dbspots It is very easy to use: just pass a date in YYYYMMDD format, and all spots older than the start of that date (00:00 UTC) will be deleted, while newer records are preserved. ### Installation Download the command from: https://raw.githubusercontent.com/EA3CV/dxspider_info/main/clear/dbspots.pl and copy it into: /spider/local_cmd/clear/ You can do this with: mkdir -p /spider/local_cmd/clear && \ wget -qO /spider/local_cmd/clear/dbspots.pl \ "https://raw.githubusercontent.com/EA3CV/dxspider_info/main/clear/dbspots.pl" && \ chmod 755 /spider/local_cmd/clear/dbspots.pl Then, from the DXSpider console, reload local commands: load/cmd ### Usage examples Example where no records match the purge criteria: clear/dbspots 20260101 No rows to delete. Cutoff: 2026-01-01 00:00:00Z (epoch 1767225600) Example where old spots are removed: clear/dbspots 20260126 Deleting 570 spot rows with time < 2026-01-24 00:00:00Z (epoch 1769212800) ... Done. Deleted: 570. Note: indexes are not harmed. After large purges you MAY run: OPTIMIZE TABLE spot; (off-peak) I hope this is useful for those running DXSpider with an SQL backend. 73 de Kin EA3CV
participants (1)
-
Kin