limit size of spamblock bayes db?

Creating and modifying plugins.
Post Reply
ju
Regular
Posts: 50
Joined: Wed Oct 01, 2008 4:27 pm

limit size of spamblock bayes db?

Post by ju » Tue Nov 13, 2012 1:54 pm

I'm just preparing to migrate s9y from my home-server to a hoster and while doing so noticed that the database is huge. sy_spamblock_bayes contains over one million of datasets, more than 30 k pages in phpmyadmin.

How can I limit the size without making it forget everything? (Now, just for the migration, and also for the future.)

User avatar
onli
Regular
Posts: 2266
Joined: Tue Sep 09, 2008 10:04 pm
Contact:

Re: limit size of spamblock bayes db?

Post by onli » Tue Nov 13, 2012 8:31 pm

Hi ju
You could try to just move a part over to the new hoster. Backup you database and try something like:

Code: Select all

CREATE VIRTUAL TABLE sy_spamblock_bayes_temp LIKE sy_spamblock_bayes;
INSERT INTO sy_spamblock_bayes_temp VALUES (
SELECT * FROM sy_spamblock_bayes LIMIT 0, 10000);
For the future: That are quite many entries I, I am not sure how this could happen, as even the tokenized words of any language shouldn't be that many. You should in every case disable auto learning.
regards

Post Reply