[GNC] Inconsistent MySQL databases

[Ira Fuchs]

My MySQL client shows tables sizes.

> On Mar 1, 2024, at 9:02 AM, Derek Atkins <derek at ihtfp.com> wrote:
> 
> 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
>