Re: Backup help

2017-09-20 Thread Art via gnucash-user
I just read your message after I sent my previous one. I was using MYSQL master-slave replication with my desktop servers and only running a client my laptop, but after realizing how quick the dump & restore was and how rarely I actually "go mobile", it was easier for me to just do the restore

Re: Backup help

2017-09-20 Thread John Ralls
> On Sep 20, 2017, at 1:35 AM, DaveC49 wrote: > > Hi Colin, > > i agree with both you and Bram there. It is not a reliable backup of the > database but really only useful for sharing a database across several > machines and worked well for the use case where my

Re: Backup help

2017-09-20 Thread DaveC49
Hi Colin, i agree with both you and Bram there. It is not a reliable backup of the database but really only useful for sharing a database across several machines and worked well for the use case where my laptop was generally connected to my LAN and I worked away from home occasionally. haven't

Re: Backup help

2017-09-20 Thread Bram Mertens
Colin, You've got that correct. Replication, just like e.g. RAID protects against some forms of data loss but it is not a full backup solution. It could be part of it though, e.g. if running a more permanent backup from the slave is easier than running it on the master. MySQL/MariaDB have

Re: Backup help

2017-09-20 Thread Colin Law
Just to point out that database replication might not be considered a good form of backup. It copes with something like a disc crash but if, for example, a user or bug were accidentally to delete large sections of the db then that deletion would be copied to the slave database. Unless I

Re: Backup help

2017-09-15 Thread Roger Oliver
Thanks. I'll try that. Everything worked as advertised on a simple USB drive so it may be a Windows issue or power on the old Windows 7 machine. On Sep 15, 2017 7:29 PM, "Art" wrote: > I'm not familiar with "WinDrive". My 5TB USB drive is Seagate Backup Plus > formatted to

Re: Backup help

2017-09-15 Thread Roger Oliver
Windows 7 and 10. Mostly interested in a backup copy off the main computer in case it crashes. Mine did, the Windows 10 machine. All my GC data was restored from the Carbonite backup. Grateful it worked. The 7 machine is at the school dedicated to accounting. I think there is something wrong with

Re: Backup help

2017-09-15 Thread Art via gnucash-user
I'm not familiar with "WinDrive". My 5TB USB drive is Seagate Backup Plus formatted to NTFS with a GPT (to handle drives larger than 2TB). Since you said you could see the files from the first machine, the data was likely there. If you cannot see any files on the same drive from the second

Re: Backup help

2017-09-15 Thread Art via gnucash-user
What are the OSes on the source and target computers?What is the external hard disk filesystem and how do you know it's compatible with both computers? I assume you are able to run GC on both computers, hence the point of copying the db to the second one. E.g., I routinely archive my db from