Re: MYSQL table crashed and doesn't repair

2003-10-06 Thread Alexis da Cruz Henriques Guia
Execute in shell myisamchk --help This will list a serie of options to repair your tables. Obviously, this only works to MyISAM tables. ;) Alexis Quoting Stanley Joseph <[EMAIL PROTECTED]>: > Dear All , > A few tables of my database crashed and are not getting repaired .What is > the best way

Re: slow performance with large "or" list in where

2003-10-05 Thread Alexis da Cruz Henriques Guia
Your problem is that MySQL don't use indeces in selects with 'or' (See MySQL manual). But i didn't have understand what's your problem executing individual selects... You don't need to open parallel connections. Put the UPDATE commands in a file, and execute them in mysql prompt like this: mysql>