How to delete old rows from my heavy DB table?

[morevsegouk]

Hi. Please help me. Here is the screenshot of Stats table that is full with old data:

 

 

How can I save my time and delete rows of all the years except 2012?

 

... even when I choose to show 1000 rows - it gets more than 2400 pages and manually it might take at least 1 day to clean old data

 

 

 

I really appreciate your help,

Presta boy

Edited May 8, 2012 by morevsegouk (see edit history)

[bellini13]

you would need to execute a SQL delete command with a where clause, something like

 

DELETE FROM `stats` WHERE `date` < '2011-12-31 23:59:59';

 

 

For reference

http://faq.nucleuscms.org/item/162

[morevsegouk]

tx - done

 

only it should be done without time (just date)

 

but - thank you!

Edited May 8, 2012 by morevsegouk (see edit history)