On Sun, 24 Feb 2019 at 19:18, Steve Isenberg via gnucash-user < [email protected]> 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 <[email protected]> > To: [email protected] > Subject: Re: [GNC] Connect MySQL to GnuCash > Message-ID: <[email protected]> > 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 > [email protected] > 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. > _______________________________________________ gnucash-user mailing list [email protected] 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.
