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
Clean up spamblocklog and visitors tables?
-
- Regular
- Posts: 139
- Joined: Sun Feb 05, 2006 12:54 am
- Location: St. Ilgen, Germany
- Contact:
Clean up spamblocklog and visitors tables?
--
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
Re: Clean up spamblocklog and visitors tables?
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
sincerely
-
- Regular
- Posts: 139
- Joined: Sun Feb 05, 2006 12:54 am
- Location: St. Ilgen, Germany
- Contact:
Re: Clean up spamblocklog and visitors tables?
Does that also apply to the visitors table?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
Greetings
Marc
--
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
-
- Core Developer
- Posts: 30022
- Joined: Tue Sep 16, 2003 9:45 pm
- Location: Cologne, Germany
- Contact:
Re: Clean up spamblocklog and visitors tables?
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
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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
-
- Regular
- Posts: 139
- Joined: Sun Feb 05, 2006 12:54 am
- Location: St. Ilgen, Germany
- Contact:
Re: Clean up spamblocklog and visitors tables?
Thanks!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
Greetings
Marc
--
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online
Marc Haber, St. Ilgen, Germany
https://blog.zugschlus.de/ - nach langer Pause jetzt wieder online