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

[Colin Law]

On 5 July 2015 at 10:02, L. D. James <ljames at apollo3.com> wrote:
> On 07/05/2015 04:34 AM, Colin Law wrote:
>>
>> On 5 July 2015 at 09:18, L. D. James <ljames at apollo3.com> wrote:
>>>
>>> ...
>>> I've only worked with a
>>> few accounting problems, I believe all of the ones I've seen perform a
>>> backup when exiting.  It appears the developers have a lot of concern for
>>> the novice computer users who neglect to backup and are later crying
>>> trying
>>> to find a way to recover their precious data once the active version
>>> becomes
>>> corrupted... just like a number of users in previous different threads
>>> have
>>> been afraid to upgrade for fear of losing their data. I've told them in
>>> each
>>> case to just backup their data, or use one of the default backed up
>>> versions.
>>
>> I don't think a novice computer user will be using mysql or
>> postgreSQL.  A system administrator setting those up must understand
>> how to maintain and back up the databases.  I don't think gnucash
>> should get involved in that.
>>
>> For sqlite I believe the database is simply a single file, so I
>> imagine in that case gnucash could use a similar backup strategy to
>> the one it uses for xml files.
>>
>> Colin
>
>
> I am an IT professions.  All the people I work with are novice computer
> users.  I don't know many doctors, lawyers, or other business professional
> and even accountants that are not novice computer users.  The normal
> computer users depend on the facilities and features built into the software
> they use.
>
> Many of the people using this mailing list are not actually novice computer
> users.  However, even these people who are not novice computer users are
> having lots of problems asking for support for doing very easy things.
> Having the features I'm describing, of which you're saying an IT person
> should get involved in are things that will make it easier for us helping in
> this list to give support to the users.
> ...
> I don't know who your clients are.  But none of my clients truly understand
> what a database engine or xml file is.  They barely understand what a zip
> archive is.  The ones who has a clue for some of this couldn't put it into
> words.

You are missing my point, I think.  No novice computer user is going
to setup mySQL.  Where a novice computer user is using mySQL there
will be a sys admin who setup the database for him/her.  I do not
believe mySQL will ever be the default, possibly it may be sqlite.
Gnucash cannot (I believe) be responsible for backup of a mySQL
database, only the system administrator can be responsible for that.
Can you suggest any other app that uses mySQL that handles database
backups within the app?

In the case of sqlite it may well be that your points are entirely
valid, as I suggested in my previous post.

Colin