database backup in Windows

On various Hardware and OS systems: pi / windows / routers / nas, etc
Post Reply
manjh
Posts: 321
Joined: Saturday 27 February 2016 13:49
Target OS: Raspberry Pi
Domoticz version: 3.8153
Location: NL
Contact:

database backup in Windows

Post by manjh » Tuesday 08 March 2016 12:59

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

User avatar
gizmocuz
Posts: 8640
Joined: Thursday 11 July 2013 18:59
Target OS: Raspberry Pi
Domoticz version: beta
Location: Top of the world
Contact:

Re: database backup in Windows

Post by gizmocuz » Tuesday 08 March 2016 18:19

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
Quality outlives Quantity!

manjh
Posts: 321
Joined: Saturday 27 February 2016 13:49
Target OS: Raspberry Pi
Domoticz version: 3.8153
Location: NL
Contact:

Re: database backup in Windows

Post by manjh » Tuesday 08 March 2016 19:07

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

Hans
Hans

User avatar
gizmocuz
Posts: 8640
Joined: Thursday 11 July 2013 18:59
Target OS: Raspberry Pi
Domoticz version: beta
Location: Top of the world
Contact:

Re: database backup in Windows

Post by gizmocuz » Wednesday 09 March 2016 9:34

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

manjh
Posts: 321
Joined: Saturday 27 February 2016 13:49
Target OS: Raspberry Pi
Domoticz version: 3.8153
Location: NL
Contact:

Re: database backup in Windows

Post by manjh » Thursday 10 March 2016 0:02

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

manjh
Posts: 321
Joined: Saturday 27 February 2016 13:49
Target OS: Raspberry Pi
Domoticz version: 3.8153
Location: NL
Contact:

Re: database backup in Windows

Post by manjh » Thursday 10 March 2016 0:11

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... :shock:

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
Hans

manjh
Posts: 321
Joined: Saturday 27 February 2016 13:49
Target OS: Raspberry Pi
Domoticz version: 3.8153
Location: NL
Contact:

Re: database backup in Windows

Post by manjh » Thursday 10 March 2016 10:21

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! :shock:
Hans

ZatarraNL
Posts: 4
Joined: Saturday 16 September 2017 9:02
Target OS: -
Domoticz version:
Contact:

Re: database backup in Windows

Post by ZatarraNL » Friday 06 October 2017 9:35

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
Posts: 10
Joined: Saturday 08 July 2017 12:36
Target OS: Windows
Domoticz version:
Contact:

Re: database backup in Windows

Post by WBTech » 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"?

Post Reply

Who is online

Users browsing this forum: No registered users and 3 guests