Serendipity Forums

Posted: **Sun Oct 19, 2008 12:48 pm**

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?

Posted: **Sun Oct 19, 2008 1:14 pm**

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

Serendipity Forums

1.2GB of visitors database problem

1.2GB of visitors database problem

Re: 1.2GB of visitors database problem