1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

prosper202 database is getting huge

Discussion in 'CPA' started by NX_NULL, Jul 9, 2012.

  1. NX_NULL

    NX_NULL Regular Member Premium Member

    Joined:
    Dec 31, 2008
    Messages:
    309
    Likes Received:
    425
    The database is getting bigger and bigger each day as I am sending bulk traffic to my landing page
    Is there any way to remove unimportant data without losing the campaign setup and links...


    In administration I see following option
    Delete All Click Data
    (Warning This clears out everything except your setup data)

    Is it safe to run? has any body tried it
     
  2. NX_NULL

    NX_NULL Regular Member Premium Member

    Joined:
    Dec 31, 2008
    Messages:
    309
    Likes Received:
    425
    any idea?

    Its risky to try it for me, because if it mess I will lose thousands of visitors until i fix the issue
     
  3. NX_NULL

    NX_NULL Regular Member Premium Member

    Joined:
    Dec 31, 2008
    Messages:
    309
    Likes Received:
    425
    any body has tried it?
     
  4. umerjutt00

    umerjutt00 Jr. VIP Jr. VIP Premium Member

    Joined:
    Oct 28, 2011
    Messages:
    3,644
    Likes Received:
    1,906
    Occupation:
    Ninja
  5. rowebil

    rowebil Regular Member

    Joined:
    Sep 20, 2010
    Messages:
    390
    Likes Received:
    51
    Location:
    Pennsylvania
    Prosper202 - I never got it to work... you should PM me so you can help me set it up! I tried tutorials, but I wasn't sure how the tracking worked.

    Couldn't you backup the database before you do anything? Then, if you mess it up, just go to your MySQL tool and just back up the database and tables.
     
  6. thejake

    thejake Jr. VIP Jr. VIP Premium Member

    Joined:
    Nov 13, 2009
    Messages:
    685
    Likes Received:
    828
    Seems strange it's an issue for you, my current 202 install has about 2 years of pretty aggressive ppv volume and the db's only 2.9 gigs.
     
  7. williamk

    williamk BANNED BANNED

    Joined:
    Oct 29, 2009
    Messages:
    1,030
    Likes Received:
    184
    Why dont you try asking them in their support forum? I am sure you will get much better answers there.
     
  8. DarkPixel

    DarkPixel Jr. VIP Jr. VIP Premium Member

    Joined:
    Oct 4, 2011
    Messages:
    1,328
    Likes Received:
    1,239
    Location:
    ↓↓↓↓
    Home Page:
    Backup the database as it is now, and try that. If that doesn't work well then import the database you exported.