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