moving to sql backend

Carpetnailz carpetnailz at researchintegration.org
Mon Sep 2 21:45:06 EDT 2013


Does GnuCash create a log file when using a mysql backend? I don't see
one in the usual directory where the xml keeps its logs.

On Mon, 2013-09-02 at 21:31 -0400, Carpetnailz wrote:
> Sounds good. Thanks.
> I think I may continue my current record-keeping with the xml version
> and experiment with the sql for a while and then maybe switch over at
> the new year.
> 
> On Mon, 2013-09-02 at 17:15 -0700, Art wrote:
> > Hi!
> > 
> > 
> > 
> > I just used the pre-built GC for Windows 7 and it supported MySQL.
> > I also built GC from source under Ubuntu (GC v2.5.4 git under Linux
> > hvs1-Linux64 3.2.0-52-generic). It took a while, but I'm not the
> > "RTFM" sort-of guy. I had the MySQL server running under Windows 7 and
> > Ubuntu Linux as a slave (mirror). I like it because I can backup my db
> > and restore as needed and I can issue SQL code to do global search and
> > replace commands. It's a sharp sword, so I only do trivial mods. One
> > false move and your database entity relationships map is shot. I tread
> > lightly. I love it because I wanted to learn more about SQL,
> > mirroring, and database recovery and GnuCash provides this along with
> > my tracking my home finances. (It replaced Microsoft Money while
> > Microsoft was pulling-out. I wanted the flexibility [freedom/power] to
> > shoot myself in the foot if I got reckless with my personal finance
> > accounting [data admin/management].)
> > 
> > 
> > MySQL support seems pretty good still, since Oracle's MySQL Workbench
> > 6.0 CE works great for me!
> > 
> > 
> > BTW, it's a bit ironic about XML because I subscribed to the idea of
> > electronic design specs being defined in XML, and I still do.
> > 
> > 
> > - Art
> > 
> > 
> > ______________________________________________________________________
> > From: Carpetnailz <carpetnailz at researchintegration.org>
> > To: Philip Tait <philip at taits.org> 
> > Cc: gnucash-user at gnucash.org 
> > Sent: Monday, September 2, 2013 4:27 PM
> > Subject: Re: moving to sql backend
> > 
> > 
> > I'm personally more comfortable with MySql than with xml and also I'm
> > hoping maybe for more reporting flexibility out of mysql. We'll see. 
> > 
> > On Mon, 2013-09-02 at 12:10 -1000, Philip Tait wrote:
> > > Last time I looked into this, there seemed to be no benefit in using
> > the
> > > MySql option. Is there now some advantage to using it?
> > > 
> > > Philip
> > > 
> > > 
> > > On Mon, Sep 2, 2013 at 12:01 PM, Liz <edodd at billiau.net> wrote:
> > > 
> > > > On Mon, 02 Sep 2013 17:49:06 -0400
> > > > Carpetnailz <carpetnailz at researchintegration.org> wrote:
> > > >
> > > > > I'm wanting to explore using a mysql backend for gnucash. All I
> > can
> > > > > find in the tutorial and help manuals is the instruction to
> > "save as"
> > > > > and select the desired sql data format.
> > > > >
> > > > > But all I see there is the xml format option, and I haven't been
> > able
> > > > > to find any instructions in the documentation on how to get
> > 'save as'
> > > > > to show a mysql option--how to actually create the the mysql
> > backend.
> > > > > The instructions seem to assume you've done it somehow. I have
> > mysql
> > > > > running on my computer and can create a database there for
> > GnuCash,
> > > > > but I need help in how to tell GnuCash to recognize it. I've
> > searched
> > > > > both the help manual and the concepts guide to no avail.
> > > > >
> > > > > Can you tell me where to find the needed info?
> > > > >
> > > > > I've got GnuCash 2.4.13 on Fedora 17.
> > > > >
> > > > > Thanks.
> > > > >
> > > >
> > > > You need a program to bridge between Gnucash and your database
> > > > backend, MySql.
> > > >
> > > > In Debian you would install libdbd-mysql.
> > > > You might find it is libdbi-mysql in Fedora - that is a previous
> > name
> > > > for the library.
> > > > _______________________________________________
> > > > 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.
> > > >
> > > _______________________________________________
> > > 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.
> > 
> > 
> > _______________________________________________
> > 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.
> > 
> > 
> > 
> 
> 
> _______________________________________________
> 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.




More information about the gnucash-user mailing list