[GNC] Inconsistent MySQL databases

[Derek Atkins]

What queries are you running to compare the two databases?

-derek

On Fri, March 1, 2024 8:53 am, Ira Fuchs wrote:
> They are precisely the same. No changes have been made during this test.
> One difference is that one MySQL is running 8.0.22 and the other is 8.0.36
> but that should not affect the gnucash data table row numbers.
>
>> On Mar 1, 2024, at 8:38 AM, Derek Atkins <derek at ihtfp.com> wrote:
>>
>> Hi
>>
>> On Fri, March 1, 2024 8:30 am, Ira Fuchs wrote:
>>> I have 2 instances of MySQL to which I save copies of my Gnucash data.
>>> I
>>> have gnucash open with an xml file and I do a save to the first
>>> instance
>>> and then I reopen the XML file and Save again, this time to another
>>> MySQL.
>>> In both cases the save proceeds normally after warning the file will be
>>> overwritten. I then examine the 2 files and in particular the number of
>>> records in the transactions, slots, and splits tables and find that
>>> they
>>> are different by 1000s of rows. (It doesn’t matter if I do the save
>>> from
>>> xml->MySQL(1)-MySQL(2) or xml->MySQL(1)-XML->MYSQL(2).
>>> Can anyone explain to me why there would be any difference in these 2
>>> SQL
>>> files?
>>
>> I cannot explain why they are different, however, in case #2 have you
>> compared the two XML files to ensure they are the same?
>>
>> -derek
>>
>>> Please remember to CC this list on all your replies.
>>> You can do this by using Reply-To-List or Reply-All.
>>
>> -derek
>>
>> --
>>       Derek Atkins                 617-623-3745
>>       derek at ihtfp.com             www.ihtfp.com
>>       Computer and Internet Security Consultant
>>
>
>


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