database backup in Windows

[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.....

[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

[manjh]

I use Chrome by default, but Edge gives me the same "backupdatabase.php"...

Hans

[gizmocuz]

Very strange as i don't experience this.... you are running domoticz version #46xx + ?

[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".

[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

[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!

[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.

[WBTech]

Hi, I have the same Windows backup problem with all browsers. Can you explain how you changed Domoticz map to the "current user"?

[manjh]

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.

[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.