CHECKSUM different between 4.0 and 5.0

Hi, Folks,

Is there any reason why there table checksums would be different, for
an identical table, between MySQL 4.1 and MySQL 5.0?

Here is what we did:
1. Install MySQL 4.1
2. Create table X.
3. CHECKSUM TABLE X; -----> 4019305494
4. Install MySQL 5.0
5. CHECKSUM TABLE X; -----> 3299794249

Thanks, in advance.

-Steve

estebanjang@gmail.com wrote:
> Hi, Folks,
>
> Is there any reason why there table checksums would be different, for
> an identical table, between MySQL 4.1 and MySQL 5.0?
>
> Here is what we did:
> 1. Install MySQL 4.1
> 2. Create table X.
> 3. CHECKSUM TABLE X; -----> 4019305494
> 4. Install MySQL 5.0
> 5. CHECKSUM TABLE X; -----> 3299794249
>
> Thanks, in advance.
>
> -Steve
>

Are these tables you created on each version specifically for testing,
or you had a used table in 4.1, and then re-created it in 5.0?

Jordan Greenberg
--
Remove the *SPAM* from my email address to reply.

--
Posted via a free Usenet account from http://www.teranews.com

estebanjang@gmail.com wrote:
> Hi, Folks,
>
> Is there any reason why there table checksums would be different, for
> an identical table, between MySQL 4.1 and MySQL 5.0?
>
> Here is what we did:
> 1. Install MySQL 4.1
> 2. Create table X.
> 3. CHECKSUM TABLE X; -----> 4019305494
> 4. Install MySQL 5.0
> 5. CHECKSUM TABLE X; -----> 3299794249
>
> Thanks, in advance.
>
> -Steve
>

Steve,

I don't think there's any guarantee about internal data formats between
releases. It doesn't surprise me at all the checksums could be different.

Basically you shouldn't be accessing the files directly anyway - only
through MySQL. And there it's the results which count, not the internal
formats.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
jstucklex@attglobal.net
==================

<estebanjang@gmail.com> schreef in bericht
news:1162433507.282094.302270@h54g2000cwb.googlegr oups.com...
> Hi, Folks,
>
> Is there any reason why there table checksums would be different, for
> an identical table, between MySQL 4.1 and MySQL 5.0?
>
> Here is what we did:
> 1. Install MySQL 4.1
> 2. Create table X.
> 3. CHECKSUM TABLE X; -----> 4019305494
> 4. Install MySQL 5.0
> 5. CHECKSUM TABLE X; -----> 3299794249
>
> Thanks, in advance.
>
> -Steve
>

the manual (http://dev.mysql.com/doc/refman/5.0/...sum-table.html)
says:
CHECKSUM TABLE reports a table checksum.

it does NOT say:
CHECKSUM TABLE reports THE table checksum.

;-)