[GNC] Connect MySQL to GnuCash

Steve Isenberg brrg58 at yahoo.com
Sun Feb 24 14:15:30 EST 2019


 That partially works. There is a non-specific error given after converting to MySQL:
 
****** Tables are created but no data is brought forward ******
ERROR Converting to MySQL

The server at URL mysql://___________/t4h_gnucash experienced an error or encountered bad or corrupt data.

****** Tables are created but no data is brought forward ******
I found a similar issue raised on Stack Overflow. No definite answer on why it occurred or how to work around it. 

Is there a solution other than writing an export script to dump all the data and then another script to load it into MySQL?
Thanks

  
*********************************************
Anyone have any tips or resources on connecting MySQL workbench to a GnuCash file?
Thanks


------------------------------

Message: 4
Date: Wed, 20 Feb 2019 20:35:24 -0600 (CST)
From: David Cousens <davidcousens at bigpond.com>
To: gnucash-user at gnucash.org
Subject: Re: [GNC] Connect MySQL to GnuCash
Message-ID: <1550716524999-0.post at n4.nabble.com>
Content-Type: text/plain; charset=us-ascii

Steve,

You will need to save the file as MySQL using the File->Save A,s if not
already done, to create the MySQL database. Once that is done it should be
no problem to connect MySQL workbench as per any other database. GnuCash
will have to have been built with support for MySQL (which is the default)
and you will have to have MySQL installed obviously.

David Cousens


https://www.gnucash.org/docs/v3/C/gnucash-guide/basics-files1.html

The SQL commands GnuCash uses to create the database are given here 
https://wiki.gnucash.org/wiki/SQL





------------------------------








  


More information about the gnucash-user mailing list