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

[Art]

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

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
 (x86)

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,

Art


________________________________
 From: Derek Atkins <derek at ihtfp.com>
To: vArt <pinaart at yahoo.com> 
Cc: Colin Law <clanlaw at googlemail.com>; "gnucash-devel at gnucash.org" <gnucash-devel at gnucash.org> 
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"?
 
hi,

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

-derek

>
>
>
> ________________________________
>  From: Colin Law <clanlaw at googlemail.com>
> To: Art <pinaart at yahoo.com>
> Cc: "gnucash-devel at gnucash.org" <gnucash-devel at gnucash.org>
> 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 yahoo.com> 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 gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-devel
>


-- 
       Derek Atkins                 617-623-3745
      derek at ihtfp.com             www.ihtfp.com
       Computer and Internet
 Security Consultant