[GNC] mysql setup in linux (debian)
Cam Ellison
cam at ellisonet.ca
Mon Feb 1 00:13:51 EST 2021
On 2021-01-31 20:05, David Cousens wrote:
> I don't have any experience of MySQL with GnuCash but I would try and
> look at
> logs for the MySQL server in /var/log/mysql. If the problem is with
> the
> server rather than GnuCash itself, that may indicate it. Also check the
> Gnucash,trace file ( https://wiki.gnucash.org/wiki/Tracefile) which
> should
> be in /tmp but is also located in /var/tmp on some systems.
Looking in the logs will work only if logging is enabled, which in
Debian it is not, by default. He'll have to set that.
It is possible that the DB was saved correctly. 3.1M in XML is not very
large, and I seem to recall encountering an error msg of some sort when
I converted from XML. Using PHPMyAdmin or similar, or logging into mysql
via CL as root should allow for determining whether the tables were
created and loaded. Alternatively, try to load the DB as a new file.
HTH
Cam
More information about the gnucash-user
mailing list