MySQL query [sic]

[Roger H. Goun]

On Wed, Nov 13, 2002 at 05:53:17PM -0500, you wrote:
> Howdy.  Sorry 'bout the horrible pun.  Anyway, I'm looking to install a
> (psuedo-)Bayesian spam filter, but the directions on how to configure
> MySQL are... lacking.  Here they are:
> 
> ..."Inside you will find 'bayesspam.sql'.  This file contains the table
> definitions that BayesSpam needs to added to a database in MySQL."
> 
> That's -it-.  I've done databases before, but not recently.  While I have
> MySQL installed, and understand the underlying concepts, I have -no- idea
> on how to execute them.  Anyone wanna give a sick-and-tired-of-spam guy a
> hand?

Off the top of my head:

# mysqladmin create database bayesspam
# mysql bayesspam < bayesspam.sql

Warning: this completely ignores security! See, for example,
<http://www.mysql.com/doc/en/Default_privileges.html>.

HTH.

-- Roger

P.S.: I've been getting amazing results (~95% caught) with ESR's
bogofilter version 0.8 <http://www.tuxedo.org/~esr/bogofilter/> with
the Robinson modification (-r) turned on. Anyone else tried it?

-- 
Roger H. Goun                  Brentwood Country Animal Hospital, P.C.
Chief Kennel Officer           Exeter, New Hampshire, USA