Backup database with new stable Topic is solved
Moderator: leecollings
-
- Posts: 17
- Joined: Wednesday 16 September 2015 5:52
- Target OS: Raspberry Pi / ODroid
- Domoticz version: V2.3774
- Contact:
Backup database with new stable
Hi everybody.
When I want to backup my database, domoticz create a file: backupdatabase.php
Why the file is not a .db extension?
I can't restore this file because domoticz wants a .db file
Any idea?
When I want to backup my database, domoticz create a file: backupdatabase.php
Why the file is not a .db extension?
I can't restore this file because domoticz wants a .db file
Any idea?
- McMelloW
- Posts: 430
- Joined: Monday 20 November 2017 17:01
- Target OS: Raspberry Pi / ODroid
- Domoticz version: V2024.1
- Location: Harderwijk, NL
- Contact:
Re: Backup database with new stable
Go to the screen Setup - Setting - tab Backup/Restore
Now hoover with your mouse over the backup button. You will see this button uses the file: backupdatabase.php
Now hoover with your mouse over the backup button. You will see this button uses the file: backupdatabase.php
Greetings McMelloW
-
- Posts: 17
- Joined: Wednesday 16 September 2015 5:52
- Target OS: Raspberry Pi / ODroid
- Domoticz version: V2.3774
- Contact:
Re: Backup database with new stable
Thanks for your response, but I don't understand what you mean with:
"hoover with your mouse over the backup button"
I saw a pop-up with myip/backupdatabase.php in the low-left corner
What do I have to do?
Sorry for my english...
"hoover with your mouse over the backup button"
I saw a pop-up with myip/backupdatabase.php in the low-left corner
What do I have to do?
Sorry for my english...
- erem
- Posts: 230
- Joined: Tuesday 27 March 2018 12:11
- Target OS: Raspberry Pi / ODroid
- Domoticz version: 2021.1
- Location: Amsterdam/netherlands
- Contact:
Re: Backup database with new stable
to backup your database from the browser,
go to [setup] - [settings], select the backup/restore tab.
then click the backup button,and a file named <location>.db will be downloaded.
<location> is the name you entered at the [setup] - [settings] system tab
to restore, select the restore button, choose the file, press upload
clear?
go to [setup] - [settings], select the backup/restore tab.
then click the backup button,and a file named <location>.db will be downloaded.
<location> is the name you entered at the [setup] - [settings] system tab
to restore, select the restore button, choose the file, press upload
clear?
Regards,
Rob
Rob
-
- Posts: 17
- Joined: Wednesday 16 September 2015 5:52
- Target OS: Raspberry Pi / ODroid
- Domoticz version: V2.3774
- Contact:
Re: Backup database with new stable
Hi erem
Thanks for your response but I think I know how to backup/ restore.
What I dont understand Is why thé generated file is a . PHP extension ans not a .dB extension.
Thanks for your response but I think I know how to backup/ restore.
What I dont understand Is why thé generated file is a . PHP extension ans not a .dB extension.
Re: Backup database with new stable
When you click that button then the database will be saved (backuped) in your download folder.
-
- Posts: 17
- Joined: Wednesday 16 September 2015 5:52
- Target OS: Raspberry Pi / ODroid
- Domoticz version: V2.3774
- Contact:
Re: Backup database with new stable
I still dont understand why the generated file is a . PHP extension and not a .dB extension
- waaren
- Posts: 6028
- Joined: Tuesday 03 January 2017 14:18
- Target OS: Linux
- Domoticz version: Beta
- Location: Netherlands
- Contact:
Re: Backup database with new stable
I tested this on Windows 10 with latest stable and latest Beta using the GUI backup button. In both cases the created backup was Domoticz.db
Any clues how to replicate your issue ?
Debian buster, bullseye on RPI-4, Intel NUC.
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
dz Beta, Z-Wave, RFLink, RFXtrx433e, P1, Youless, Hue, Yeelight, Xiaomi, MQTT
==>> dzVents wiki
Re: Backup database with new stable
Try to backup with the button on a different PC.
It might be that your current PC just saves a .php file with a click on that button.
It might be that your current PC just saves a .php file with a click on that button.
-
- Posts: 17
- Joined: Wednesday 16 September 2015 5:52
- Target OS: Raspberry Pi / ODroid
- Domoticz version: V2.3774
- Contact:
Re: Backup database with new stable (SOLVED)
Hi.
I solved my problem! (I still have others problems)
I needed to give total access to C:\Program Files (x86)\Domoticz
Thanks for your help!
I solved my problem! (I still have others problems)
I needed to give total access to C:\Program Files (x86)\Domoticz
Thanks for your help!
-
- Posts: 343
- Joined: Friday 17 August 2018 14:03
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Re: Backup database with new stable
I have a problem with the backup as well:
- As of feb also domoticz.db-shm and domoticz.db-wal are backuped up. In essence not a big problem, however In the hourly dir The domoticz.db-wal file has a size of 825M, which causes the growth of the directory tree. In the monthly tree the file is stil bigger (biggest i also bigger, but not 64m. In the monthly tree is has a normal size. The size of this file is weird, since in size of the file being backup up is only 11M.
- But the worst thing is: domoticz.db itself is not backupped anymore as of feb 8th. (in any directory). I am on the beta channel and do updates every now and then, so i probably did an upgrade to latest version that day.
For just disabled the auto backup (it doesn't work now), but i would really like this to work, so
- Does anyone have similar experience (or let me know if it works in your case)
- Does anyone know how to fix?
Here are all the details of my analysis:
1st. These are my file sizes of the production db
My hourly backups (last backup of .db at feb 9. shm files are enormous)
My daily backups: (still big .wal files, but not as big in hourly dir. last backup of domoticz.db feb 9th)
And my monthly backups: (normal size wal files, last succeed backup of .db in januari)
in the logging at every backup there are no errors: I only get these 2 loglines
- As of feb also domoticz.db-shm and domoticz.db-wal are backuped up. In essence not a big problem, however In the hourly dir The domoticz.db-wal file has a size of 825M, which causes the growth of the directory tree. In the monthly tree the file is stil bigger (biggest i also bigger, but not 64m. In the monthly tree is has a normal size. The size of this file is weird, since in size of the file being backup up is only 11M.
- But the worst thing is: domoticz.db itself is not backupped anymore as of feb 8th. (in any directory). I am on the beta channel and do updates every now and then, so i probably did an upgrade to latest version that day.
For just disabled the auto backup (it doesn't work now), but i would really like this to work, so
- Does anyone have similar experience (or let me know if it works in your case)
- Does anyone know how to fix?
Here are all the details of my analysis:
1st. These are my file sizes of the production db
Code: Select all
-rwxr-xr-x 1 domoticz domoticz 7,3M apr 19 07:47 domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K apr 19 07:49 domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 11M apr 19 07:49 domoticz.db-wal*
Code: Select all
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 00:00 backup-hour-00-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 00:00 backup-hour-00-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 818M apr 19 00:00 backup-hour-00-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 01:00 backup-hour-01-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 01:00 backup-hour-01-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 818M apr 19 01:00 backup-hour-01-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 02:00 backup-hour-02-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 02:00 backup-hour-02-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 811M apr 19 02:00 backup-hour-02-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 03:00 backup-hour-03-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 03:00 backup-hour-03-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 818M apr 19 03:00 backup-hour-03-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 04:00 backup-hour-04-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 04:00 backup-hour-04-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 818M apr 19 04:00 backup-hour-04-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 05:00 backup-hour-05-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 05:00 backup-hour-05-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 818M apr 19 05:00 backup-hour-05-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 06:00 backup-hour-06-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 06:00 backup-hour-06-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 818M apr 19 06:00 backup-hour-06-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 07:00 backup-hour-07-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 07:00 backup-hour-07-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 819M apr 19 07:00 backup-hour-07-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 08:00 backup-hour-08-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 19 08:00 backup-hour-08-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 782M apr 19 08:00 backup-hour-08-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 09:00 backup-hour-09-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,5M apr 18 09:00 backup-hour-09-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 760M apr 18 09:00 backup-hour-09-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 10:00 backup-hour-10-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 10:00 backup-hour-10-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 779M apr 18 10:00 backup-hour-10-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 11:00 backup-hour-11-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 11:00 backup-hour-11-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 791M apr 18 11:00 backup-hour-11-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 12:00 backup-hour-12-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 12:00 backup-hour-12-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 791M apr 18 12:00 backup-hour-12-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 13:00 backup-hour-13-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 13:00 backup-hour-13-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 785M apr 18 13:00 backup-hour-13-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 14:00 backup-hour-14-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,5M apr 18 14:00 backup-hour-14-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 767M apr 18 14:00 backup-hour-14-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 15:00 backup-hour-15-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 15:00 backup-hour-15-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 793M apr 18 15:00 backup-hour-15-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 16:00 backup-hour-16-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 16:00 backup-hour-16-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 798M apr 18 16:00 backup-hour-16-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 17:00 backup-hour-17-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 17:02 backup-hour-17-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 798M apr 18 17:02 backup-hour-17-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 18:00 backup-hour-18-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 18:00 backup-hour-18-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 806M apr 18 18:00 backup-hour-18-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 19:00 backup-hour-19-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 19:00 backup-hour-19-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 818M apr 18 19:00 backup-hour-19-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 20:00 backup-hour-20-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 20:00 backup-hour-20-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 806M apr 18 20:00 backup-hour-20-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 21:00 backup-hour-21-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 21:00 backup-hour-21-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 805M apr 18 21:00 backup-hour-21-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 22:00 backup-hour-22-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,6M apr 18 22:00 backup-hour-22-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 814M apr 18 22:00 backup-hour-22-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 23:00 backup-hour-23-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 1,7M apr 18 23:00 backup-hour-23-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 825M apr 18 23:00 backup-hour-23-Domoticz.db-wal*
Code: Select all
-rwxr-xr-x 1 domoticz domoticz 11M jan 1 00:00 backup-day-01-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 1 00:00 backup-day-01-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 32M apr 1 00:00 backup-day-01-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 2 00:00 backup-day-02-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 2 00:00 backup-day-02-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 32M apr 2 00:00 backup-day-02-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 3 00:00 backup-day-03-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 3 00:00 backup-day-03-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M apr 3 00:00 backup-day-03-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 4 00:00 backup-day-04-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 4 00:00 backup-day-04-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M apr 4 00:00 backup-day-04-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 5 00:00 backup-day-05-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 5 00:00 backup-day-05-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M apr 5 00:00 backup-day-05-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 6 00:00 backup-day-06-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 6 00:00 backup-day-06-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 26M apr 6 00:00 backup-day-06-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 7 00:00 backup-day-07-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 7 00:00 backup-day-07-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 26M apr 7 00:00 backup-day-07-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 8 00:00 backup-day-08-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K apr 8 00:00 backup-day-08-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 14M apr 8 00:00 backup-day-08-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M feb 9 00:00 backup-day-09-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K apr 9 00:00 backup-day-09-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 15M apr 9 00:00 backup-day-09-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 10 00:00 backup-day-10-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 10 00:00 backup-day-10-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 26M apr 10 00:00 backup-day-10-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 11 00:00 backup-day-11-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 11 00:00 backup-day-11-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 26M apr 11 00:00 backup-day-11-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 12 00:00 backup-day-12-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K apr 12 00:00 backup-day-12-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 15M apr 12 00:00 backup-day-12-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 13 00:00 backup-day-13-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K apr 13 00:00 backup-day-13-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 15M apr 13 00:00 backup-day-13-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 14 00:00 backup-day-14-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K apr 14 00:00 backup-day-14-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 15M apr 14 00:00 backup-day-14-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M jan 15 00:00 backup-day-15-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 15 00:00 backup-day-15-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 26M apr 15 00:00 backup-day-15-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M jan 16 00:00 backup-day-16-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K apr 16 00:00 backup-day-16-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 26M apr 16 00:00 backup-day-16-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 17 00:00 backup-day-17-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 96K apr 17 00:00 backup-day-17-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 38M apr 17 00:00 backup-day-17-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 18 00:00 backup-day-18-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 96K apr 18 00:00 backup-day-18-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 37M apr 18 00:00 backup-day-18-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 19 00:00 backup-day-19-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 96K apr 19 00:00 backup-day-19-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 37M apr 19 00:00 backup-day-19-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 20 00:00 backup-day-20-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 20 00:00 backup-day-20-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 30M mrt 20 00:00 backup-day-20-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 21 00:00 backup-day-21-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 21 00:00 backup-day-21-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 30M mrt 21 00:00 backup-day-21-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 13M dec 22 00:00 backup-day-22-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 22 00:00 backup-day-22-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 30M mrt 22 00:00 backup-day-22-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 23 00:00 backup-day-23-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 23 00:00 backup-day-23-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M mrt 23 00:00 backup-day-23-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 24 00:00 backup-day-24-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 24 00:00 backup-day-24-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M mrt 24 00:00 backup-day-24-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 25 00:00 backup-day-25-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 25 00:00 backup-day-25-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M mrt 25 00:00 backup-day-25-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 26 00:00 backup-day-26-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 26 00:00 backup-day-26-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M mrt 26 00:00 backup-day-26-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 27 00:00 backup-day-27-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 27 00:00 backup-day-27-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 31M mrt 27 00:00 backup-day-27-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 28 00:00 backup-day-28-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 28 00:00 backup-day-28-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 32M mrt 28 00:00 backup-day-28-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 12M dec 29 00:00 backup-day-29-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 29 00:00 backup-day-29-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 32M mrt 29 00:00 backup-day-29-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M dec 30 00:00 backup-day-30-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 30 00:00 backup-day-30-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 18M mrt 30 00:00 backup-day-30-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 11M dec 31 00:00 backup-day-31-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 64K mrt 31 00:00 backup-day-31-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 18M mrt 31 00:00 backup-day-31-Domoticz.db-wal*
Code: Select all
-rwxr-xr-x 1 domoticz domoticz 11M jan 1 00:00 backup-month-01-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 6,1M feb 1 2019 backup-month-02-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K feb 1 00:00 backup-month-02-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 12M feb 1 00:00 backup-month-02-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 6,5M mrt 1 2019 backup-month-03-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K mrt 1 00:00 backup-month-03-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 14M mrt 1 00:00 backup-month-03-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 6,7M apr 1 2019 backup-month-04-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 32K apr 1 00:00 backup-month-04-Domoticz.db-shm*
-rwxr-xr-x 1 domoticz domoticz 6,9M apr 1 00:00 backup-month-04-Domoticz.db-wal*
-rwxr-xr-x 1 domoticz domoticz 6,9M mei 1 2019 backup-month-05-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 7,6M jun 1 2019 backup-month-06-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 8,3M jul 1 2019 backup-month-07-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 7,9M aug 1 2019 backup-month-08-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 10M sep 1 2019 backup-month-09-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 7,5M okt 1 2019 backup-month-10-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 6,9M nov 1 00:00 backup-month-11-Domoticz.db*
-rwxr-xr-x 1 domoticz domoticz 7,4M dec 1 00:00 backup-month-12-Domoticz.db*
in the logging at every backup there are no errors: I only get these 2 loglines
Code: Select all
2020-04-19 08:00:00.880 Status: Starting automatic database backup procedure...
2020-04-19 08:00:28.452 Status: Ending automatic database backup procedure...
Re: Backup database with new stable
Try:
Edit!
Not necessary, because I saw in the source that a VACUUM and Optimize is already done before the backup.
Code: Select all
sudo systemctl stop domoticz.service
sqlite3 /home/pi/domoticz/domoticz.db "VACUUM;";
sudo systemctl start domoticz.service
Not necessary, because I saw in the source that a VACUUM and Optimize is already done before the backup.
-
- Posts: 343
- Joined: Friday 17 August 2018 14:03
- Target OS: Raspberry Pi / ODroid
- Domoticz version:
- Contact:
Re: Backup database with new stable
tx for your response. out of curiosity: Do you use automated backup? And if so … does it work for you?EddyG wrote: ↑Sunday 19 April 2020 9:32 Try:Edit!Code: Select all
sudo systemctl stop domoticz.service sqlite3 /home/pi/domoticz/domoticz.db "VACUUM;"; sudo systemctl start domoticz.service
Not necessary, because I saw in the source that a VACUUM and Optimize is already done before the backup.
Re: Backup database with new stable
I have a Synology 1517+ NAS and I do a lot of backups by scripting myself and run by cron. I don't use Domoticz internal backup.
1. Every 5 minutes is the Domoticz database of every Pi saved on the NAS for 3 days, 864 backups per Pi. Takes 16 Gb.
2. Every day I backup my domoticz directory to the NAS. Only takes 200 Mb.
3. Every 4 hours (for 4 weeks) I run system snapshot to an attached USB drive, which is daily copied to the NAS. Takes 4 Gb per Pi.
4. Every hour a Synology LUN snapshot is taken for 3 days, 8 weeks, 12 months ( My Pi's run from a LUN, see my sig.)
I sounds paranoia, but I have the space on the NAS (10 Tb in raid) and it saved me overtime a lot time/work.
1. Every 5 minutes is the Domoticz database of every Pi saved on the NAS for 3 days, 864 backups per Pi. Takes 16 Gb.
2. Every day I backup my domoticz directory to the NAS. Only takes 200 Mb.
3. Every 4 hours (for 4 weeks) I run system snapshot to an attached USB drive, which is daily copied to the NAS. Takes 4 Gb per Pi.
4. Every hour a Synology LUN snapshot is taken for 3 days, 8 weeks, 12 months ( My Pi's run from a LUN, see my sig.)
I sounds paranoia, but I have the space on the NAS (10 Tb in raid) and it saved me overtime a lot time/work.
Who is online
Users browsing this forum: No registered users and 0 guests