moving to sql backend

[Carpetnailz]

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.
> 
> 
>