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

[L. D. James]

On 07/05/2015 02:59 PM, Geert Janssens wrote:
> On Saturday 04 July 2015 18:10:00 L. D. James wrote:
>> I have found the backups of gnucash to be very invaluable.  In order
>> to facilitate a client with their accounting (access from home and
>> work) I'm exploring the mysql data feature.
>>
>> I'm having problems locating where the backups are stored.  Can
>> someone help?
>>
>> Thanks.
>>
>> -- L. James
> When using the mysql backend there are no backups. I've read part of
> your motivations on why you would like to have them, but it just wasn't
> implemented.
>
> It's also pretty hard to do. Not everybody controls the mysql server
> that is used to store the gnucash data. So automatically creating new
> databases as backups for the main database are not always
> possible/desired. Copying databases takes a lot of time also. Combine
> this with the fact that the sql backend writes on change this would mean
> that a new backup has to be made for each change you make. That would
> cause A LOT of database overhead.
>
> So the automatic backups were not implemented. The idea back then was
> that if you are using mysql you probably are proficient enough in system
> administration to manage backups yourself.
>
I didn't mean, backup of the mysql data base.  Also, I agree with you.  
I decided not to give access to the user account to create new 
databases.  My suggestion was an export to something similar to what you 
are already using with your "save as".

My use of the word, "backup", was a mistake.  You already have the 
feature that I was describing.  Again, the feature in it's current state 
is, "save as".  It works perfectly in it's current state.  I'm hoping 
that you will consider this "save as" feature that you already have as a 
user's preference configuration to specify a directory on his local 
system, and automatically "save as" when exiting, giving the files an 
incremental name.

To me that would be better than nothing.

By the way this thread had been going, I'm sure there can be a hundred 
reasons not to.  But I hope you don't mind me addressing and helping 
with those reasons one by one.

Again, the feature already exist.  I use it.  Just before exiting, I 
click on "save as", save the state, then exit.  I'm just asking for 
considerations of saving a step by having it do this automatically when 
I click on exit... or better yet, have it prompt the user to save when 
exiting.

-- L. James

-- 
L. D. James
ljames at apollo3.com
www.apollo3.com/~ljames