Prosper202 database cleanup

[Unarmed Gunman]

I use several tracking domains like most people and I always back up my databases, but one of my installs database is fucking enormous and I need a quick and dirty way in phpmyadmin to drop all the records from before a set date (such as May 1, 2010 or whatever) so I can clean it up temporarily and just have the last couple of months worth of data retained in the current DB, before I do a fresh install. I remember seeing an easy solution to this in a thread awhile back but was too distracted by tits or something to bookmark it. Thanks.

 

[bbrock32]

Bump! I have the same problem and don't want to experiment since I'm afraid I might delete redirect links or other important things. Anyone has any idea how to do this without fucking the prosper db?

 

[WesMahler]

TO CLEAR OUT ALL OF YOUR CLICK DATA (BUT TO KEEP ALL OF THE INPUTS YOU'VE CREATED, IE: PPC NETWORKS, CAMPAIGNS, LP SETUPS, TRACKERS) DO THE FOLLOWING

Truncate/Empty the following tables

202_clicks
202_clicks_advance
202_clicks_record
202_clicks_site
202_clicks_spy
202_clicks_tracking
202_clicks_updates
202_cronjobs
202_delayed_sqls
202_ips
202_keywords
202_last_ips
202_site_domains
202_site_urls
202_summary_overview

--

This will clear all of your data but retain the inputs you've entered into prosper202 over a course of time. Everything will track on-forward from here.

If you only want to clear out a particular date it gets a-little bit to complicated to easily do anything. I'd suggest dumping your existing database and booting up a new prosper202 interface to access the old data. Then clear out your database and just use it for new click tracking.

This should work on any P202 versions that are 1.5.1 or newer

 

[bbrock32]

Good idea Wes. Thanks!