As mentioned in another request http://board.s9y.org/viewtopic.php?f=4&t=19004 I'm preparing for moving my s9y installation to another server. During 4 years the database has grown quite a bit. I don't have the original size any more but in 2009 the db-dump was some 800 KB and now it is 272 MB.
I wonder if I can "downsize" it a little bit before migrating. For instance there are over 1 million datasets in the spamblock bayes, of which I could certainly delete some. I also noticed that every single visit from years ago can still be found in the database.
Where else could I look for tables that have grown too large and be either emptied altogether or where I can delete at least the oldest datasets without losing important information and withou destroying something that is essential for s9y to funktion?
Which db-tables can I empty before migration?
Re: Which db-tables can I empty before migration?
You could use serendipity_event_dbclean to check, if there are some unnecessary entries in tables spamblocklog, spamblock_htaccess, visitors, referrers and exits, before you export database.
Re: Which db-tables can I empty before migration?
Please read
http://board.s9y.org/viewtopic.php?f=2&t=9107
Its only for statistic use, so truncating or empty the table won't harm Serendipity to work.
Same for visitor table.
http://board.s9y.org/viewtopic.php?f=2&t=9107
Its only for statistic use, so truncating or empty the table won't harm Serendipity to work.
Same for visitor table.
Regards,
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Ian
Serendipity Styx Edition and additional_plugins @ https://ophian.github.io/ @ https://github.com/ophian
Re: Which db-tables can I empty before migration?
Thank you! This was the explanation I was looking for (but with the wrong catch-words).