1.2GB of visitors database problem

[murdocha]

Hi All

Bit of a problem with my database.

It has one table 1.2GB in size of simply visitors data.

Can I use phpMYAdmin to simply empty this table of its contents?

[garvinhicking]

Hi!

Yes, you can simply use phpmyadmin to either empty the whole table (empty, NOT delete/drop!) or you can use a query like this to only delete visitor data older than 6 months:

Code: Select all

DELETE FROM serendipity_visitors WHERE UNIX_TIMESTAMP(day) < UNIX_TIMESTAMP('2008-04-01');

Everything earlier than 2008-04-01 will then be removed.

HTH,
Garvin