Serendipity Forums

Posted: **Tue Nov 13, 2012 12: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.)

Posted: **Tue Nov 13, 2012 7: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

Serendipity Forums

limit size of spamblock bayes db?

limit size of spamblock bayes db?

Re: limit size of spamblock bayes db?