Using MySQL with GnuCash

Hossain contacthossain at gmail.com
Mon Sep 14 15:54:50 EDT 2015


Actually I wanted the same as u said. Multiple instance to work with the 
same Database,
which I think is NOT possible in GNUCash. Any recommendation of another 
free/open source
application which allows this wud be highly appreciated. Thanx a lot .

On 15-Sep-2015 1:51 AM, Colin Law wrote:
> On 14 September 2015 at 20:47, Hossain <contacthossain at gmail.com> wrote:
>> IS there any work around ? what if I use the option "create a new file"
>> offered above.
>> What does it do ? IS there any way I can do this ?
> You cannot edit data in one database by two instances of gnucash at
> the same time, the software does not cope with that and you will get
> data corruption.
>
> You can have two separate databases open at the same time just as you
> can have two separate xml files open.
>
> What exactly is it that you want to do?
>
> Colin
>
>>
>> On 15-Sep-2015 1:45 AM, Colin Law wrote:
>>> On 14 September 2015 at 20:41, Hossain <contacthossain at gmail.com> wrote:
>>>> I did it  but GNUCash from remote PC can only use MySQL , when the Server
>>>> PC
>>>> is not using another GNUCash ( two application at  d same time). When
>>>> Server
>>>> PC
>>>> is already running GNUCash, starting another GNUCash from client PC says
>>>> "GUNCASH
>>>> couldnt obtain the lock for mysql://gunuser@192.168.0.102/gnucash. That
>>>> database
>>>> maybe in use by another user, in which case you shoudnt open the
>>>> database,
>>>> What wud
>>>> u like to do? " It has 4 options- Open Read Only, Create New File, Open
>>>> Anyway, Quit .
>>>> I dont know wat to do now. I want to use GNUCash at d same time from two
>>>> PCs.
>>> You can't.  Gnucash does not yet support multiple users at the same
>>> time, even when using mysql.
>>>
>>> Colin
>>



More information about the gnucash-user mailing list