Resuming. Re: Is there a step-by-step, "How to setup a MySQL database for use with GnuCash"?

Art pinaart at
Sat Aug 25 17:20:12 EDT 2012

I restored my 7/7/12 image with GnuCash v2.4.10 and was able to save the default file GnuCash tomysql://root@

I did a File -> Quit and noticed it should "Unsaved ..." in the panel title as GnuCash exited.

I restarted GnuCash and it had test25 as the default. The splash screen icon shows "GnuCash (Not Responding)". 5-10 minutes later, Windows brings up the "not responding" Debug/Close pop-up and I close it.

I restart GnuCash and cancel test25. The panel says "Unsaved GnuCash". I do File -> Open -> "GnuCash" and do saveas test25a and it says error or bad or corrupted data. I try test25b and get the same error. I reload the file GnuCash and try to saveas mysql://root@localhost/test25c which also fails with the same error message.

I see the lock file, GnuCash.LCK and it goes away when I exit GnuCash. I also noticed MySQL had crashed or the service had stopped running because the MySQL commandline console would close when I tried to login to check status.
The Windows services panel says, "Service status: Started", so I do "Stop", then 10 seconds later, "Start". But I can't login.
I exit GnuCash, now I can login (as root).
The status is,

F:\usr\MySQL\MySQL Server 5.5\bin\mysql.exe  Ver 14.14 Distrib 5.5.24, for Win64

Connection id:          1
Current database:
Current user:           root at localhost
SSL:                    Not in use
Using delimiter:        ;
Server version:         5.5.24 MySQL Community Server (GPL)
Protocol version:       10
Connection:             localhost via TCP/IP
Server characterset:    latin1
Db     characterset:    latin1
Client characterset:    latin1
Conn.  characterset:    latin1
TCP port:               3306
Uptime:                 1 min 52 sec

Threads: 1  Questions: 4  Slow queries: 0  Opens: 33  Flush tables: 1  Open tabl
es: 26  Queries per second avg: 0.035
Now I get "Error", "Unspecified fatal error encountered, aborting."
When I dismiss that pop-up, I get the "Microft Visual C++ Runtime Library", "This application has requested the Runtime to terminate in an unusual way."
This time I don't believe it's my fault per se. I probably do need to reboot, but my Windows 7 is up-to-date with all it's updates, except I may have needed to do one more reboot since that last updates were applied.

I had taken extensive notes on this issue,but wanted to provide fresh information right now.

Thank you,


 From: Derek Atkins <derek at>
To: vArt <pinaart at> 
Cc: Colin Law <clanlaw at>; "gnucash-devel at" <gnucash-devel at> 
Sent: Friday, August 24, 2012 2:18 PM
Subject: Re: Is there a step-by-step, "How to setup a MySQL database for use with GnuCash"?

On Fri, August 24, 2012 4:08 pm, Art wrote:
> Correct. It hangs when I try to open the same db it saved.
> Any subsequent re-starts of GnuCash do the same for that database.

How did you exit GnuCash after your File -> Save As?
What happens if you click "open anyways"?

> - Art


> ________________________________
>  From: Colin Law <clanlaw at>
> To: Art <pinaart at>
> Cc: "gnucash-devel at" <gnucash-devel at>
> Sent: Friday, August 24, 2012 12:57 PM
> Subject: Re: Is there a step-by-step, "How to setup a MySQL database for
> use with GnuCash"?
> On 24 August 2012 20:53, Art <pinaart at> wrote:
>> Hi!
>> I don't know if I should ask this in a different forum, but I've
>> experimented with GnuCash for several years, but recently wanted to just
>> use the MySQL database for my finances and GnuCash can never read them.
>> It can create a database which I can read from the MySQL commandline
>> interface, but GnuCash simply hangs when I try doing it from it.
> Do you mean that
 if you do Save As and select the mysql option that it
> creates the db ok, but then if you close and re-open gnucash that it
> does not re-open the mysql db?
> Colin
> [deleted my text below for brevity - Art]
> _______________________________________________
> gnucash-devel mailing list
> gnucash-devel at

       Derek Atkins                 617-623-3745
      derek at   
       Computer and Internet
 Security Consultant

More information about the gnucash-devel mailing list