Results 1 to 3 of 3

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

  1. #1
    Thread Starter
    Veteran helmuc's Avatar
    Join Date
    Jan 2011
    Location
    Maidstone, UK
    Posts
    356
    Thanks
    112
    Thanked 37 Times in 34 Posts

    Question 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


    Helmuts | VLSA London Limited, UK www.VLSA.com <> We provide Secure and Reliable central London Business Addresses

    Outlived Classifieds: https://www.outlived.co.uk

  2. #2
    Thread Starter
    Veteran helmuc's Avatar
    Join Date
    Jan 2011
    Location
    Maidstone, UK
    Posts
    356
    Thanks
    112
    Thanked 37 Times in 34 Posts
    just an update:


    here is a screenshot of Structure tab:


    anybody?


    Helmuts | VLSA London Limited, UK www.VLSA.com <> We provide Secure and Reliable central London Business Addresses

    Outlived Classifieds: https://www.outlived.co.uk

  3. #3
    Thread Starter
    Veteran helmuc's Avatar
    Join Date
    Jan 2011
    Location
    Maidstone, UK
    Posts
    356
    Thanks
    112
    Thanked 37 Times in 34 Posts
    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


    Helmuts | VLSA London Limited, UK www.VLSA.com <> We provide Secure and Reliable central London Business Addresses

    Outlived Classifieds: https://www.outlived.co.uk

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Admin Table Width data base cant find the table
    By testfinder in forum Report ClassiPress Bugs
    Replies: 6
    Last Post: December 5th, 2011, 07:49 PM
  2. [MOD NEEDED] Is it possible to show sub-categories as rows, instead of columns?
    By ibs75 in forum ClassiPress General Discussion
    Replies: 3
    Last Post: January 28th, 2011, 11:11 AM
  3. rows instead of columns --- help please
    By salota8550 in forum ClassiPress General Discussion
    Replies: 5
    Last Post: January 2nd, 2011, 07:05 PM
  4. I think the heavy Classipress in navigation ...
    By dandra in forum ClassiPress General Discussion
    Replies: 5
    Last Post: June 30th, 2009, 11:56 AM