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

Wm wm+gnc at tarrcity.demon.co.uk
Sun Jul 5 10:36:25 EDT 2015


Sat, 4 Jul 2015 18:10:00 <559859B8.7050002 at apollo3.com>  L. D. James
<ljames at apollo3.com>

>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'll present a slightly different response to others by asking a Q
why not continue using xml for daily use since it offers a number of
benefits including backups and logs and (basic) access control and write
to SQL storage when necessary (before analysis, week or month ends, etc)

If you need an SQL backend for analysis purposes SQLite3 (still single
file) is the logical first point.

xml, sqlite3, mysql and postgres are *still* *just* *storage* for gnc.
everything is done in memory,

        with the SQL backends the writes are immediate

        with XML you have save timing control, logs, backups, the whole
        caboodle.

what's not to like?  if you're worried about users using the sql backend
after a save to sql give 'em an icon / shortcut to the xml file, gnc
will pick that up.

Enterprise scale dbm's offer very little to gnc storage that SQLite3
can't and offer a whole lot of headaches.  i.e. you need a *reason* for
using an SQL backend, and once you've got your reason you need another
reason to use an enterprise level db and after that (my opinion) you
need a reason to use MySQL as it is the least suited to gnc.

P.S. some personal opinions involved above but in keeping with gnc
forward thinking, I believe and hopefully a pause for thought.

-- 
Wm...


More information about the gnucash-user mailing list