Where does Gnucash save it backup files when using mysql data source

[David G Hamblen]

On 07/05/2015 10:21 AM, Colin Law wrote:
> On 5 July 2015 at 10:47, L. D. James <ljames at apollo3.com> wrote:
>> When I first started using Peachtree, as far as I know, it was a bunch of
>> local files very similar to the way Gnucash started out. Eventually they
>> incorporated a database engine.  It's a very powerful engine.  I can
>> research and give you the name of it.  The Linux version of the engine is
>> extremely expensive.
> If that comment is in answer to my request for examples of
> applications that use mySQL and do database backups within the apps, I
> am not particularly familiar with Peachtree but I don't think it uses
> mySQL.  I think it uses the Pervasive database which is a very
> different beast to mySQL.  A big difference I think is that Pervasive
> is intended to be embedded within an app, whereas mySQL uses an
> external server over which gnucash has little control.

I use Peachtree extensively at work (GC at home) and yes, Peachtree uses 
Pervasive, but their backups are simply a zip file of the entire data 
directory.  They've got a Windows script which sets up the equivalent of 
a cron job to do the zip backup to anywhere (I automatically backup to 
an off-site server every two days).  So doing a compressed xml export as 
previous posters have suggested would be good.  (I do that manually 
about once a month at home - SaveAs, followed by reopening the mysql db.)
...
(snip)
...


gnucash-user mailing list gnucash-user at gnucash.org 
https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please 
remember to CC this list on all your replies. You can do this by using 
Reply-To-List or Reply-All.

-- 
dhamblen at afrinc.com
home phone (207) 633-4342
Cell Phone (207) 350-0440