My MySQL client shows tables sizes. > On Mar 1, 2024, at 9:02 AM, Derek Atkins <de...@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 <de...@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 >>> de...@ihtfp.com www.ihtfp.com >>> Computer and Internet Security Consultant >>> >> >> > > > -- > Derek Atkins 617-623-3745 > de...@ihtfp.com www.ihtfp.com > Computer and Internet Security Consultant >
_______________________________________________ gnucash-user mailing list gnucash-user@gnucash.org To update your subscription preferences or to unsubscribe: https://lists.gnucash.org/mailman/listinfo/gnucash-user ----- Please remember to CC this list on all your replies. You can do this by using Reply-To-List or Reply-All.