Which db-tables can I empty before migration?

[ju]

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?

[bernd_d]

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.

[Timbalu]

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.

[ju]

Thank you! This was the explanation I was looking for (but with the wrong catch-words).