On 22 March 2018 at 07:39, daniel <daniel.or...@gmail.com> wrote: > Hello, > > I'm using two machines (both are Ubuntu 16.04) and trying to use MySQL to > save GnuCash data. > In one machine the GnuCash application in the second one MySQL. > > While trying to save the data (with Save As, MySQL option) I provide the > MySQL information (Host, DB, User and Pass). > > In MySQL I see that the database was created as well as the tables. > > However, I get an error in GnuCash - The Server at URL:// experienced an > error or encountered bad or corrupt data. > > If I try to save agian with the same MySQL information I get: > The file already exits. Are you sure you want to overwrite it ? > Answering Yes creates another set of tables with _back suffix to all tables.
The _back tables are (I think) backups of the ones before the save. The normally named tables should contain the correct data. Did the save succeed this time? If it still did not succeed check that the user has full access to the database. Also which version of gnucash and which version of SQL sever are you using? Colin _______________________________________________ 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.
