[GNC] Connect MySQL to GnuCash

[Colin Law]

On Sun, 24 Feb 2019 at 19:18, Steve Isenberg via gnucash-user <
gnucash-user at gnucash.org> wrote:

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

I don't understand under what situation you are getting that error, and
where you are seeing the error

Colin


>
> 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
>
>
>
>
>
> ------------------------------
>
>
>
>
>
>
>
>
>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> To update your subscription preferences or to unsubscribe:
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> If you are using Nabble or Gmane, please see
> https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>