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

[AC]

On 2015-07-04 16:59, L. D. James wrote:

> Thanks Dave.  I understand how to back up my computer and all my date. 
> I've always known how to do this even when using the data files. 
> However, I find it very convenient that when actually using Gnucash, it
> actually backs up the data.  The data is backed-up when you use it.  If
> you don't open Gnucash for days or weeks it won't be backed up (by
> Gnucash).  The feature backs up the data when it's actually being used.
> 
> If I use it 10 times different in one day, it'll actually be backed up
> those 10 times.  Again, I find this extremely convenient.
> 
> I can backup the mysql data 10 or 20 times a day, but if it's only used
> once or twice on some days and not used on some days, that might be a
> lot of backing up.  Also if I only back up the mysql files once a day
> and it happens to get loaded and used 10 times that day, the
> functionality for reviewing the most recent change is gone.
> 
> I don't know if this has been considered by the developers, but it's
> something they might consider.
> 
> In the meantime, I'll write a routine for mine to regularly check the
> gnucash database for any changes or activity and back make a backed-up
> version when this happens.  I wouldn't consider it as efficient as the
> built-in backup facility of Gnucash itself, but it's something that
> might come in handy if something gets corrupted when it's being used.

One other item regarding your desire to review changes when using a
database engine.  The changes are immediate since they're written to the
database.  The way to accomplish what you want involves either enabling
transaction logging in MySQL where every SQL command is logged to the
file (enabling you to see any changes) or you must run a transaction
logging replication server which will accept any data changing command
(update/insert/delete) into some kind of paired transaction where the
old data is flagged and the new data is appended to the table.  This is
a much bigger proposition.