moving to sql backend

[Art]

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.