[GNC] Inconsistent MySQL databases

[Ira Fuchs]

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
>