RE: Strange "Mull" in show fields and table keeps crashing

2003-06-25 Thread Victor Pendleton
Do you have any sort of `shell` access to the box? SSH? Telnet? -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 25, 2003 9:51 AM To: [EMAIL PROTECTED] Subject: Re: Strange "Mull" in show fields and table keeps crashing I'm not s

Re: Strange "Mull" in show fields and table keeps crashing

2003-06-25 Thread Karl J. Stubsjoen
t; To: "'Karl J. Stubsjoen'" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 2:20 PM Subject: RE: Strange "Mull" in show fields and table keeps crashing > The `MUL` indicates that the column have multiple values. When the server > `cr

RE: Strange "Mull" in show fields and table keeps crashing

2003-06-24 Thread Mike Hillyer
MUL indicates a that the column is part of a composite INDEX. SHOW INDEX FROM tablename Should let you know what columns make up the MUL column INDEX. If this was not supposed to be indexed, your table is corrupt, best try MyIsamChk Regards, Mike Hillyer www.vbmysql.com > -Original Messa

Re: Strange "Mull" in show fields and table keeps crashing

2003-06-24 Thread Jocelyn Fournier
Hi, What about upgrading to MySQL 4.0.13 ? 4.0.0 is not a "production" release, and a lot of bugs have been fixed between 4.0.0 and 4.0.13. Regards, Jocelyn - Original Message - From: "Karl J. Stubsjoen" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Tuesday, June 24, 2003 11:13 P

RE: Strange "Mull" in show fields and table keeps crashing

2003-06-24 Thread Victor Pendleton
The `MUL` indicates that the column have multiple values. When the server `crashes`, what errors are being reported log file? -Original Message- From: Karl J. Stubsjoen [mailto:[EMAIL PROTECTED] Sent: Tuesday, June 24, 2003 4:13 PM To: [EMAIL PROTECTED] Subject: Strange "Mull" in show fiel