Using MySQL with GnuCash

[Colin Law]

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
>
>