Hi, I will give the output below. I just ran an insert of a small amount of data into Windoz/MySQL 5.0.6. Then, I ran a "myisampack" agains it. Finally, I ran a myisamchk against it and keep coming up against this error: Found wrong record at 687081
Now, I'm the only one who has access to this database. What's is going on? Can anyone help me? Enclosed is the output of each step below. Regards, George E:\MySQLData\5.0.6\sdidw>myisampack -v --tmpdir=e:\workdir table.MYI Compressing table.MYD: (100349 records) - Calculating statistics normal: 9 empty-space: 0 empty-zero: 1 empty-fill: 9 pre-space: 0 end-space: 0 intervall-fields: 4 zero: 14 Original trees: 55 After join: 32 - Compressing file Min record length: 39 Max length: 58 Mean total length: 46 77.63% Remember to run myisamchk -rq on compressed tables E:\MySQLData\5.0.6\sdidw>myisamchk --tmpdir=e:\workdir -rqp --sort-index --analyze mytable.MYI - check record delete-chain - parallel recovering (with sort) MyISAM-table 'mytable.MYI' Data records: 100349 - Fixing index 1 - Fixing index 2 - Fixing index 3 - Fixing index 4 - Fixing index 5 - Fixing index 6 - Fixing index 7 - Fixing index 8 - Fixing index 9 - Fixing index 10 - Fixing index 11 Found wrong record at 687081 E:\MySQLData\5.0.6\sdidw> __________________________________________________________________ Switch to Netscape Internet Service. As low as $9.95 a month -- Sign up today at http://isp.netscape.com/register Netscape. Just the Net You Need. New! Netscape Toolbar for Internet Explorer Search from anywhere on the Web and block those annoying pop-ups. Download now at http://channels.netscape.com/ns/search/install.jsp -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
