Re: [GNC] Inconsistent MySQL databases

2024-03-01 Thread Ira Fuchs
Good point and indeed doing it that way gives consistent sizes. I’ll let the client developer know. > On Mar 1, 2024, at 9:24 AM, Derek Atkins wrote: > > Hi, > > On Fri, March 1, 2024 9:21 am, Ira Fuchs wrote: >> My MySQL client shows tables sizes. > > I would never trust that different

Re: [GNC] Inconsistent MySQL databases

2024-03-01 Thread Derek Atkins
Hi, On Fri, March 1, 2024 9:21 am, Ira Fuchs wrote: > My MySQL client shows tables sizes. I would never trust that different versions of databases would store it the same way.. Use a Query to see how much data is in the table. For example: select count(*) from XXX; This will tell you how

Re: [GNC] Inconsistent MySQL databases

2024-03-01 Thread Ira Fuchs
My MySQL client shows tables sizes. > On Mar 1, 2024, at 9:02 AM, Derek Atkins 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. >>

Re: [GNC] Inconsistent MySQL databases

2024-03-01 Thread 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

Re: [GNC] Inconsistent MySQL databases

2024-03-01 Thread 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 wrote: > > Hi > > On Fri, March 1,

Re: [GNC] Inconsistent MySQL databases

2024-03-01 Thread Derek Atkins
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

[GNC] Inconsistent MySQL databases

2024-03-01 Thread Ira Fuchs
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