se myisamchk on them, and it seems to correct the problem,
but the problem comes back.
Any ideas?
-------
David Block
[EMAIL PROTECTED]
http://bioinfo.pbi.nrc.ca/dblock/wiki
NRC Plant Biotechnology Institute
Saskatoon, SK, Canada
-
Nice query, Braxton. I was trying to do it with a left join, but that
required splitting Table2 into an OFF table and an ON table.
I must remember count(1/(condition)); it seems to be very useful.
Back to my real work...
---
David Block
[EMAIL PROTECTED]
http://bioinfo.pbi.nrc.ca
s that have only
> > ALL ons relating to them. I
> > do not want a combination of
> > off, off or on, off etc...
> >
> > The only way I have been able
> > to accomplish this was to count
> > the number of instances for each
> > table and save them in temp
Bit me a few weeks ago. It's a permissions problem- mysql doesn't have
permissions to read the file, therefore it does not exist.
cd /var/lib/mysql
chown mysql */*
chgrp mysql */*
Then it will work.
-------
David Block
[EMAIL PROTECTED]
http://bioinfo.pbi.nrc.ca/dblock/wiki
