Page 1 of 1
database backup in Windows
Posted: Tuesday 08 March 2016 11:59
by manjh
I am running a Domoticz installation on a Win10 server, and am looking for the best way to make backups of the settings.
I tried to tick the box "automatic backup", but get an error message in the log saying that it failed.
Also tried to go to setup-->settings-->backup/restore and clicked the backup button, but that gives me a downloaded file "backupdatabase.php" on my local machine.
Is that it?
When I click the restore button and then navigate to the downloads folder, the system looks for a database file which is not there. When I change the filetype to "all files" I can select the php file, but am reluctant to try to restore.....
Re: database backup in Windows
Posted: Tuesday 08 March 2016 17:19
by gizmocuz
did you try to make a backup with different browsers? What is chrome doing? Also backupdatabase.php ?
Hope not... not here anyway
If you open the database in SQLite Expert Personal, and it finds it a real database, then you should have no problems restoring it
Re: database backup in Windows
Posted: Tuesday 08 March 2016 18:07
by manjh
I use Chrome by default, but Edge gives me the same "backupdatabase.php"...
Hans
Re: database backup in Windows
Posted: Wednesday 09 March 2016 8:34
by gizmocuz
Very strange as i don't experience this.... you are running domoticz version #46xx + ?
Re: database backup in Windows
Posted: Wednesday 09 March 2016 23:02
by manjh
Domoticz server claims to be V3-4834.
I just tried again, pressing the backup button on the backup/restore tab simply gives me a downloaded file "backupdatabase.php".
Re: database backup in Windows
Posted: Wednesday 09 March 2016 23:11
by manjh
This is the error from the automatic backup. Do I need to configure something in order for this to work properly?
Also, it would be nice if there was some more information. Just "Error writing... etc" is not very informative...
2016-03-09 23:00:04.587 Error: Error writing automatic hourly backup file
2016-03-09 23:00:08.306 Error: Error writing automatic daily backup file
2016-03-09 23:00:12.150 Error: Error writing automatic monthly backup file
Re: database backup in Windows
Posted: Thursday 10 March 2016 9:21
by manjh
Got it. I checked if the directories existed (under Domoticz/Backup), and that was OK. But when I checked the security tab of the properties I noticed the access was restricted.
I changed the authorizations, and now I see files being created in the hourly directory. I'm confident the other backups will follow in due time.
So: problem solved, but I don't understand why these directories were restricted... oh well, sometimes you can't understand everything!

Re: database backup in Windows
Posted: Friday 06 October 2017 9:35
by ZatarraNL
Same problem here too. Installed domoticz in C:\Program Files (x86). Owner was administrator.
After changing the owner of the domoticz map to myself (current user), backup succeeded.
Re: database backup in Windows
Posted: Wednesday 11 July 2018 18:39
by WBTech
Hi, I have the same Windows backup problem with all browsers. Can you explain how you changed Domoticz map to the "current user"?
Re: database backup in Windows
Posted: Monday 16 July 2018 17:13
by manjh
WBTech wrote: ↑Wednesday 11 July 2018 18:39
Hi, I have the same Windows backup problem with all browsers. Can you explain how you changed Domoticz map to the "current user"?
Standard windows. Find the map in the explorer, right click, properties, security. From there you should be able to change what you need.
Re: database backup in Windows
Posted: Friday 20 July 2018 10:46
by WBTech
Thanks for the answer, I did it this way, but the backup still doesn't work, because Windows doesn't save the changes I made. I need to find what's blocking the saving of the change.