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.