How to delete old rows from my heavy DB table?

Discussion in 'Databases' started by helmuc, May 8, 2012.

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

    [​IMG]

    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 :(
    [​IMG]

    I really appreciate your help,
    Helmuts
     
    helmuc, May 8, 2012 IP
  2. helmuc

    helmuc Well-Known Member

    Messages:
    42
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #2
    just an update:

    here is a screenshot of Structure tab:
    [​IMG]

    anybody??
     
    helmuc, May 8, 2012 IP
  3. helmuc

    helmuc Well-Known Member

    Messages:
    42
    Likes Received:
    1
    Best Answers:
    0
    Trophy Points:
    103
    #3
    The question can be closed - it is sorted - I have already removed the data by running SQL query... - found a detailed solution in another forum.

    tx anyway,
    Have a good day
    Helmuts
     
    helmuc, May 8, 2012 IP
  4. imranamen6

    imranamen6 Active Member

    Messages:
    947
    Likes Received:
    4
    Best Answers:
    1
    Trophy Points:
    98
    Digital Goods:
    1
    #4
    Can you please post the query for our future reference..
     
    imranamen6, May 14, 2012 IP
  5. fatur_cell

    fatur_cell Peon

    Messages:
    4
    Likes Received:
    0
    Best Answers:
    0
    Trophy Points:
    0
    #5
    be careful. you must check and make sure isn't that table link with another tables?
     
    fatur_cell, Jul 10, 2012 IP