[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