[GNC] MySQL

[Colin Law]

On Wed, 6 Mar 2019 at 19:09, Keith Bellairs <keith at bellairs.org> wrote:
>
> gnucash.trace is empty.
>
> Of some interest, I did a Save As to sqlite and it worked. So the xml data is acceptable to that DB.
>
> XML -> sqlite  OK
> XML -> mysql NG
> sqlite -> mysql NG
>
> I tried to do a Save As from the sqlite db to MySQL. That Save As ground away for a few minutes and then threw the same bad data error. So I am guessing that I have a problem with my mysql server. But of course the error log for mysql is clean.
>
> There may be some mysql magic I am missing. Since I don't live there I may not push on it much longer.

Can you connect to the database using the command line utility with
that user/pwd you specified?
Has it created the database when you look from the command line?

Colin