Re: Adding index fails with error 1034: 126

2003-04-01 Thread Chad Hanna
In message <[EMAIL PROTECTED]>, Andrew Braithwaite <[EMAIL PROTECTED]> writes Hi, What are the sizes of your index files? (i.e. name_index2.MYI in the datadir). It's a complete guess but with a large table like that, it's possible that you're reaching some kind of limit with your os/mysql setup d

RE: Adding index fails with error 1034: 126

2003-04-01 Thread Andrew Braithwaite
Hi, What are the sizes of your index files? (i.e. name_index2.MYI in the datadir). It's a complete guess but with a large table like that, it's possible that you're reaching some kind of limit with your os/mysql setup due to file size. (greater than 4 GB would be my guess) Cheers, Andrew