4019305494 4. Install MySQL 5.0 5. CHECKSUM TABLE X; -----> 3299794249 Thanks, in advance. -Steve [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <1162433507.282094.302270@h54g2000cwb.googlegroups.com> [ref] => [htmlstate] => on_nl2br [postusername] => estebanjang@gmail.com [ip] => estebanjang@gma [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 1 [islastshown] => [isfirstshown] => 1 [attachments] => [allattachments] => ) --> 4019305494 > 4. Install MySQL 5.0 > 5. CHECKSUM TABLE X; -----> 3299794249 > > Thanks, in advance. > > -Steve >[/ref] 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 [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <454960D2.4090001@wit.edu> [ref] => <1162433507.282094.302270@h54g2000cwb.googlegroups.com> [htmlstate] => on_nl2br [postusername] => Jordan [ip] => green*SPAM*berg [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 2 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> 4019305494 > 4. Install MySQL 5.0 > 5. CHECKSUM TABLE X; -----> 3299794249 > > Thanks, in advance. > > -Steve >[/ref] 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. net ================== [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <65udnWEJfIOA59TYnZ2dnUVZ_q2dnZ2d@comcast.com> [ref] => <1162433507.282094.302270@h54g2000cwb.googlegroups.com> [htmlstate] => on_nl2br [postusername] => Jerry [ip] => jstucklex@attgl [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 3 [islastshown] => [isfirstshown] => [attachments] => [allattachments] => ) --> 4019305494 > 4. Install MySQL 5.0 > 5. CHECKSUM TABLE X; -----> 3299794249 > > Thanks, in advance. > > -Steve >[/ref] the manual (http://dev.mysql.com/doc/refman/5.0/en/checksum-table.html) says: CHECKSUM TABLE reports a table checksum. it does NOT say: CHECKSUM TABLE reports THE table checksum. ;-) [allowsmilie] => 1 [showsignature] => 0 [ipaddress] => [iconid] => 0 [visible] => 1 [attach] => 0 [infraction] => 0 [reportthreadid] => 0 [isusenetpost] => 1 [msgid] => <454a54f8$0$334$e4fe514c@news.xs4all.nl> [ref] => <1162433507.282094.302270@h54g2000cwb.googlegroups.com> [htmlstate] => on_nl2br [postusername] => Luuk [ip] => luuk@invalid.la [isdeleted] => 0 [usergroupid] => [membergroupids] => [displaygroupid] => [password] => [passworddate] => [email] => [styleid] => [parentemail] => [homepage] => [icq] => [aim] => [yahoo] => [msn] => [skype] => [showvbcode] => [showbirthday] => [usertitle] => [customtitle] => [joindate] => [daysprune] => [lastvisit] => [lastactivity] => [lastpost] => [lastpostid] => [posts] => [reputation] => [reputationlevelid] => [timezoneoffset] => [pmpopup] => [avatarid] => [avatarrevision] => [profilepicrevision] => [sigpicrevision] => [options] => [akvbghsfs_optionsfield] => [birthday] => [birthday_search] => [maxposts] => [startofweek] => [referrerid] => [languageid] => [emailstamp] => [threadedmode] => [autosubscribe] => [pmtotal] => [pmunread] => [salt] => [ipoints] => [infractions] => [warnings] => [infractiongroupids] => [infractiongroupid] => [adminoptions] => [profilevisits] => [friendcount] => [friendreqcount] => [vmunreadcount] => [vmmoderatedcount] => [socgroupinvitecount] => [socgroupreqcount] => [pcunreadcount] => [pcmoderatedcount] => [gmmoderatedcount] => [assetposthash] => [fbuserid] => [fbjoindate] => [fbname] => [logintype] => [fbaccesstoken] => [newrepcount] => [vbseo_likes_in] => [vbseo_likes_out] => [vbseo_likes_unread] => [temp] => [field1] => [field2] => [field3] => [field4] => [field5] => [subfolders] => [pmfolders] => [buddylist] => [ignorelist] => [signature] => [searchprefs] => [rank] => [icontitle] => [iconpath] => [avatarpath] => [hascustomavatar] => 0 [avatardateline] => [avwidth] => [avheight] => [edit_userid] => [edit_username] => [edit_dateline] => [edit_reason] => [hashistory] => [pagetext_html] => [hasimages] => [signatureparsed] => [sighasimages] => [sigpic] => [sigpicdateline] => [sigpicwidth] => [sigpicheight] => [postcount] => 4 [islastshown] => 1 [isfirstshown] => [attachments] => [allattachments] => ) --> CHECKSUM different between 4.0 and 5.0 - MySQL
Professional Web Applications Themes

CHECKSUM different between 4.0 and 5.0 - MySQL

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...

  1. #1

    Default 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 Guest

  2. #2

    Default Re: CHECKSUM different between 4.0 and 5.0

    com wrote: 

    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

    Jordan Guest

  3. #3

    Default Re: CHECKSUM different between 4.0 and 5.0

    com wrote: 

    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.
    net
    ==================
    Jerry Guest

  4. #4

    Default Re: CHECKSUM different between 4.0 and 5.0


    <com> schreef in bericht
    news:googlegroups.com... 

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

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

    ;-)



    Luuk Guest

Similar Threads

  1. WebDav Server has moved. How do I correct for IP checksum?
    By Ray_Gubala@adobeforums.com in forum Adobe Acrobat Macintosh
    Replies: 2
    Last Post: January 11th, 09:20 PM
  2. Shockwave DMG Checksum Error
    By Naomi2 in forum Macromedia Shockwave
    Replies: 0
    Last Post: December 29th, 04:30 PM
  3. SHOW TABLES and CHECKSUM TABLE statements
    By estebanjang@gmail.com in forum MySQL
    Replies: 5
    Last Post: October 28th, 05:01 PM
  4. Checksum errors using CPAN module
    By Paul Galbraith in forum PERL Modules
    Replies: 0
    Last Post: May 19th, 05:42 AM
  5. Checksum Algorithm/Collisions
    By David in forum Microsoft SQL / MS SQL Server
    Replies: 1
    Last Post: July 15th, 08:23 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 81 82 83 84 85 86 87 88 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139