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 many rows are in the table, which will be MUCH more
accurate that looking at "table size."
-derek
>
>> 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
>>
>
>
--
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.
