Thread: How to delete old rows from my heavy DB table?

How to delete old rows from my heavy DB table?

Hi. Although this problem isn't connected with Classipress - but maybe somebody knows the answer?

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,
Helmuts

just an update:


here is a screenshot of Structure tab:


anybody?

The question can be closed - it is sorted - I have removed the data by running SQL query... - found a detailed solution in another forum.


tx anyway,
Have a good day
Helmuts