Mosquitto.db file Automatic delete

Hi Everyone

If i keep for 7 days persistance check my data while be stored inside the Mosquitto.db file on 7th day
if i subscribe to the topic and Ethernet is pluged in i will get all the data to the broker which is stored inside the mosquitto.db file…how can we delete that mosquitto.db file or can it be automatically deleted after the data published to broker

The behaviour you describe is exactly what should happen - once a message queued for a client session is delivered, it will be removed from the persistence store. If you are referring to retained messages however, the messages will only be removed when the retained message itself is removed - by sending a retained message to the same topic, but with a zero length payload.

I hope that helps.