On Sat, 17 Nov 2018 at 22:31, Peter Holck <[email protected]> wrote: > > Thanks for your suggestion. No, with only my new instance of MySQL running > (8.13 running, 5.6 stopped) when I use the GnuCash API to create a new shell > database (shelldb) and try to save as mysql, I get the same error: "The > server at URL mysql://root@localhost/shelldb experienced an error or > encountered bad or corrupt data". It seems to me the GnuCash API is looking > for an instance of my old version of MySQL (5.6) and if it's not running, > then it fails.
You haven't told us what you found when you looked in the trace file. Colin > > On Sat, Nov 17, 2018 at 3:20 PM Colin Law <[email protected]> wrote: >> >> Are you able to Save As mysql with the new server? >> Also have a look in the trace file and see what it says, often it will >> give more information in the case of db problems. >> >> Colin >> On Sat, 17 Nov 2018 at 22:07, Peter Holck <[email protected]> wrote: >> > >> > I recently installed an updated version of MySQL Server (8.13) on my >> > machine. I have an established GnuCash database under an instance of MySQL >> > 5.6. I copied all GnCash db/tables from that older version of MySQL to an >> > identically named database/tables in MySQL 8.13. >> > >> > How do I get the GnuCash API to connect to my new instance of MySQL (8.13) >> > ? If I stop my older MySQL 5.6 service and just have my MySQL 8.13 running, >> > and then attempt to start GnuCash it asks for username and password (also >> > identical for the two different MySQL versions) but then gives the standard >> > error that the server encountered bad or corrupt data. >> > >> > Thanks in advance. >> > _______________________________________________ >> > 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.
