Measure to prevent database growing

Use this forum to discuss possible implementation of a new feature before opening a ticket.
A developer shall edit the topic title with "[xxx]" where xxx is the id of the accompanying tracker id.
Duplicate posts about the same id. +1 posts are not allowed.

Moderators: leecollings, remb0

Kedi
Posts: 577
Joined: Monday 20 March 2023 14:41
Target OS: Raspberry Pi / ODroid
Domoticz version:
Location: Somewhere in NL
Contact:

Re: Measure to prevent database growing

Post by Kedi »

BartSr wrote: Wednesday 06 September 2023 19:39 bit late with my reaction but let me say it's quit impressive!
I once had a script doing also a daily backup of db + some maps but there seemed to be kind of bug so that the maps wouldnot backup.
might it be possible to share your scripts?
TIA
-Bart
I use rsnapshot and rsync to backup some dirs every 4 hours to SD-drive. https://wiki.archlinux.org/title/Rsnapshot

I will comeback on my 5 min. backup of the database script, have to clean it up.
Logic will get you from A to B. Imagination will take you everywhere.
BartSr
Posts: 395
Joined: Sunday 03 July 2016 16:16
Target OS: Raspberry Pi / ODroid
Domoticz version: V2024.7
Location: Netherlands
Contact:

Re: Measure to prevent database growing

Post by BartSr »

Hi Kedi,
I've been away some weeks from the forum. Thanks for your information. Need to dig into the documentation of course.
"https://linux.die.net/" I did not see before but very, very helpfull Thanks so much!
-Bart
Raspberry pi 3b
Arduino
KAKU
RfxCom
Zwave2MQTT
OTGW
Chinese sensors temp (Dallas),movement
Tasmota
Esp8266 / 32 espeasy
Zigbee2MQTT
Kedi
Posts: 577
Joined: Monday 20 March 2023 14:41
Target OS: Raspberry Pi / ODroid
Domoticz version:
Location: Somewhere in NL
Contact:

Re: Measure to prevent database growing

Post by Kedi »

My 5 min. database backup script is here: viewtopic.php?t=40756
Logic will get you from A to B. Imagination will take you everywhere.
Post Reply

Who is online

Users browsing this forum: No registered users and 1 guest