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
    384
    Thanks
    115
    Thanked 41 Times in 38 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 | My ClassiPress hobby site: Outlived Classifieds: https://www.outlived.co.uk

    ❤️ $2.49 / 1.99 - 100GB Space, 1 TB Traffic, Unlimited Domains, Daily Backups, Free SSL Certificates > SSD Cloud Hosting > HostMaria.com

  2. #2
    Thread Starter
    Veteran helmuc's Avatar
    Join Date
    Jan 2011
    Location
    Maidstone, UK
    Posts
    384
    Thanks
    115
    Thanked 41 Times in 38 Posts
    just an update:


    here is a screenshot of Structure tab:


    anybody?


    🇬🇧 Helmuts | My ClassiPress hobby site: Outlived Classifieds: https://www.outlived.co.uk

    ❤️ $2.49 / 1.99 - 100GB Space, 1 TB Traffic, Unlimited Domains, Daily Backups, Free SSL Certificates > SSD Cloud Hosting > HostMaria.com

  3. #3
    Thread Starter
    Veteran helmuc's Avatar
    Join Date
    Jan 2011
    Location
    Maidstone, UK
    Posts
    384
    Thanks
    115
    Thanked 41 Times in 38 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 | My ClassiPress hobby site: Outlived Classifieds: https://www.outlived.co.uk

    ❤️ $2.49 / 1.99 - 100GB Space, 1 TB Traffic, Unlimited Domains, Daily Backups, Free SSL Certificates > SSD Cloud Hosting > HostMaria.com

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, 06: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, 10:11 AM
  3. rows instead of columns --- help please
    By salota8550 in forum ClassiPress General Discussion
    Replies: 5
    Last Post: January 2nd, 2011, 06:05 PM
  4. I think the heavy Classipress in navigation ...
    By dandra in forum ClassiPress General Discussion
    Replies: 5
    Last Post: June 30th, 2009, 10:56 AM