Page 1 of 1

Clean up spamblocklog and visitors tables?

Posted: Sat Nov 07, 2009 11:00 am
by Zugschlus
Hi,

I would like to clean up my spamblocklog and visitors tables as they take up quite a big amount of disk space. Do I break my s9y installation by simply zapping all records older than january 2009 according to Unix timestamp (spamblocklog) or date/time (visitors)?

Or does s9y have a high-level frontend function to clean up?

Greetings
Marc

Re: Clean up spamblocklog and visitors tables?

Posted: Sat Nov 07, 2009 12:33 pm
by onli
As far as I know, you can even delete the spamblocklogtable, reinstall the plugin, and the table should get recreated. If you delete the content of the table a reinstall of the plugin shouldn't be necessary.
sincerely

Re: Clean up spamblocklog and visitors tables?

Posted: Sat Nov 07, 2009 12:39 pm
by Zugschlus
onli wrote:As far as I know, you can even delete the spamblocklogtable, reinstall the plugin, and the table should get recreated. If you delete the content of the table a reinstall of the plugin shouldn't be necessary.
sincerely
Does that also apply to the visitors table?

Greetings
Marc

Re: Clean up spamblocklog and visitors tables?

Posted: Sat Nov 07, 2009 12:46 pm
by garvinhicking
Hi!

s9y has no high level function for that yet, sadly. But you can easily truncate (not drop) the table, without the need to reinstall a plugin. Of course, first backup the data you want to backup :)

Regards,
Garvin

Re: Clean up spamblocklog and visitors tables?

Posted: Sun Nov 08, 2009 9:41 am
by Zugschlus
garvinhicking wrote:s9y has no high level function for that yet, sadly. But you can easily truncate (not drop) the table, without the need to reinstall a plugin. Of course, first backup the data you want to backup :)
Thanks!

Greetings
Marc