Hello, I am following the advice of the manual when bulk loading a large table by turning off index builds before LOAD DATA INFILE. The load ends normally (73 GB). The mysamchk build of the indices fails:
myisamchk: warning: Can't change size of indexfile, error: 22 myisamchk: error: 22 for record at pos 121201294124 myISAM-table 'mytable' is not fixed because of errors This process works successfully on "small" tables (37 GB) on another 2003 machine. What am I doing wrong? I'm new to MySQL, and am just finding my way. The command I'm issuing is: myisamchk -O sort_buffer_size=512M -O key_buffer_size=768M -O read_buffer_size=512M -O write_buffer_size=512M -rq d:\mysql\data\mydb\mytable I have 4GB of memory on the machine. I searched for this problem with Google and found several others with the same problem, but didn't find a solution. Thanks, Jim Gallagher -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]