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.)
limit size of spamblock bayes db?
Re: limit size of spamblock bayes db?
Hi ju
You could try to just move a part over to the new hoster. Backup you database and try something like:
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
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);
regards