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
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>