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 <davidcous...@bigpond.com> To: gnucash-user@gnucash.org Subject: Re: [GNC] Connect MySQL to GnuCash Message-ID: <1550716524999-0.p...@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@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.
