database backup in Windows

On various Hardware and OS systems: pi / windows / routers / nas, etc
Post Reply
manjh
Posts: 334
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: 8651
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: 334
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: 8651
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: 334
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: 334
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: 334
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: 12
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"?

manjh
Posts: 334
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 » Monday 16 July 2018 17:13

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

WBTech
Posts: 12
Joined: Saturday 08 July 2017 12:36
Target OS: Windows
Domoticz version:
Contact:

Re: database backup in Windows

Post by WBTech » Friday 20 July 2018 10:46

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.

Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests