"Saving as" mysql database.

[Paddy Walker]

On Sunday 08 August 2010 17:41:09 Geert Janssens wrote:
> On Sunday 8 August 2010, Paddy Walker wrote:
> > 	I have gnucash 2.2.9 as my "production system" for my business accounts.
> > 
> > It does everything I require of it very well.
> > 
> > 	I have installed gnucash 2.3.13 from Fedora 13 on a second bootable hard
> > 
> > drive. My intention is to save my data file as a mysql database and query
> > 
> >  it using OpenOffice Base on a read only basis. Eventually I hope to use
> >  Sun Report Builder to produce management reports.
> >  
> > 	 Unfortunately, I have fallen at the first fence. "Save as" only lists
> > 	 xml
> > 
> > as a drop down. I have a working installation of mysql  with permissions
> > granted to me as a user. I have created a database gnucash. I have not
> > specifically installed libdbi driver.
> > 
> > 	Please could someone direct me to instructions to getting gnucash to
> > 
> > recognise mysql.
> > 
> > 	Thank you.
> > 
> > Paddy Walker
> > _______________________________________________
> > 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.
> 
> Hi,
> 
> GnuCash uses libdbi to talk to the supported databases and by default
> libdbi is installed when GnuCash gets installed. However, libdbi itself
> has separate plugins for each database it can talk to. Each of these
> plugins is optional and probably not installed by default. If the plugins
> are missing, gnucash won't offer you the option to connect to that
> particular database.
> 
> Is libdbi-dbd-mysql installed on your system ?
> 
> Geert
Thank you John & Gaert for your VERY prompt reply. yum install libdbi-dbd-
mysql and a dependency sorted it.
Over fence 1.
Installed ConnectorJ.
Over fence 2.
Now for the query.
Paddy.