| Author |
|
niels
Newbie
Joined: September 23 2007
Location: United States
Online Status: Offline
Posts: 12
|
| Posted: September 29 2007 at 23:37 | IP Logged
|
|
|
When I run my nightly backup on the machine that runs PowerHome, do I need to shut it down prior to the backup in order to ensure that the backed-up database file is in a consistent state?
Even better, is there an easy way to make PH do a dump of its entire DB which I can safely backup, then later import like I do with Oracle and MySQL?
Niels.
|
| Back to Top |
|
| |
niels
Newbie
Joined: September 23 2007
Location: United States
Online Status: Offline
Posts: 12
|
| Posted: September 30 2007 at 00:01 | IP Logged
|
|
|
Looks like ph_backupdb is what I need.
|
| Back to Top |
|
| |
ginigma
Senior Member
Joined: June 18 2006
Location: United States
Online Status: Offline
Posts: 127
|
| Posted: September 30 2007 at 23:17 | IP Logged
|
|
|
Yep. My actual command is as follows:
ph_backupdb ("C:\HA\PowerHome\Database\Backups\phdbbackup." + string (year (today ())) + string (month (today()), "00") + string (day (today()), "00") + ".db", 0)
I run it daily overnight and that gives each file a unique name.
__________________
Insteon (40 devices) ^ PowerHome (435 links) ^ Logitech Harmony 880
|
| Back to Top |
|
| |
Active Topics 
Memberlist 
Search 
Help
Register 
Login
PowerHome Messageboard : PowerHome General
Topic: Nightly Backups
