Michael Parker wrote:
On Tue, May 10, 2005 at 05:36:53PM +0100, Tim Bishop wrote:
I've been running with bayes in a MySQL database for a while now, and I need to start dealing with cleaning up users who are no longer here. I also have AWL and configuration in the database.
So, I think I'm looking at something like the following to delete someone's data from the database:
1. Delete all entries in spamassassin.awl where the username is the user
I want to get delete.
2. Delete all entries in spamassassin.userpref where the username is the
user I want to delete.
Yeah, this is pretty much the best way to do this right now.
3. Delete all the entries in bayes_expire, bayes_seen, and bayes_token
where the id matches the id field in bayes_vars for the username.
4. Delete the entry in bayes_vars for the username.
Best way to do this is with sa-learn: sa-learn -u <username you want to remove> --clear
Why is that?
While on the subject, what about sa-learn --backup vs. mysqldump for backups?
And then, while at bayes in SQL, does bayes_seen and bayes_expire grow forever? What exactly are those table used for?
Arvinn
