Using MySQL with GnuCash

Colin Law clanlaw at gmail.com
Mon Sep 14 15:22:26 EDT 2015


On 14 September 2015 at 17:45, Hossain <contacthossain at gmail.com> wrote:
> Thnk u , I think the problem was creating the Database manually at the
> beginning.
> The GNU create the database itself, but does it mean I cant change the name
> of DB ?

The Save As dialog allows you to specify the db name

Colin

>
>
> On 14-Sep-2015 9:14 PM, Colin Law wrote:
>>
>> On 14 September 2015 at 15:56, Hossain <contacthossain at gmail.com> wrote:
>>>
>>> Hello, I want to save the GNUCash data to MySQL server , Hence, I
>>> installed
>>> WAMP.
>>> GnuCash can connect to MySQL server very well but I dont see any related
>>> database tables or data
>>> in the database I made for Gnucash with PhpAdmin. Do I have to set the
>>> saving preference at the beginningm when I make the file?
>>> I did it later.
>>
>> You don't need to make the database in advance, GnuCash will make it
>> if necessary when you save it.  Just select mysql as the type to save
>> as and provide the database name, user and password and it should do
>> it.  You should then be able to see the data in phpadmin.
>>
>> Does GC appear to save the data as mysql ok?
>> Does mysql://.... then appear in the GC title bar?
>> Can you close GC and and re-open it and the data are still there?
>> If so then it is saving the data ok so if you can't see it in
>> phpmyadmin then the problem lies there not in gc.  You may have to
>> refresh phpmyadmin after saving in GC.
>>
>> Colin
>
>


More information about the gnucash-user mailing list