We use mybackup.pl - a perl script found on sourceforge (well, not
anymore I just looked). It creates a compressed tarball of each
database, with a file for each table. The files can be used with the
mysql client without change to rebuild a table. It also can be setup to
rotate the backups base
You can try to force an index with:
SELECT * FROM Posts USE INDEX(index4) WHERE Board = 'board1' ORDER BY
Board DESC, Number DESC
Mike
-Original Message-
From: Michael Bonfert [mailto:[EMAIL PROTECTED]]
Sent: Thursday, March 28, 2002 9:06 AM
To: [EMAIL PROTECTED]
Subject: Problem w
would be great here, but I've neer had
much luck with those, and a few times I've had results returned that
were wrong with a multi column index on the table.
Thanks for looking at this,
Mike
-Original Message-
From: Christopher Thompson [mailto:[EMAIL PROTECTED]]
Sent: Monday,
I'm nearing the end of my rope trying to figure this one out. I have
some queries run against a table that is a log of hits from a web
server. No matter how simple I've tried to make my query, MySQL sill
does not choose an index. Even use index has no effect.
My table:
CREATE TABLE access_log
