how do you delete openx history? - GoFuckYourself.com

BareBacked · 12-21-2012, 10:06 AM

I have an install with a 10 gig mysql . How can I remove all the old data ?

EddyTheDog · 12-21-2012, 10:08 AM

If you want get rid of ALL the data just re-install.

Not sure if there is a way of just trimming the database.

BareBacked · 12-21-2012, 10:12 AM

I dont wnat to get rid of all the banners zones etc
just the clicks logs and huge files

EddyTheDog · 12-21-2012, 10:17 AM

Quote:

Originally Posted by BareBacked

I dont wnat to get rid of all the banners zones etc
just the clicks logs and huge files

Maybe this?

http://stackoverflow.com/questions/2...all-statistics

BareBacked · 12-21-2012, 11:27 AM

Quote:

Originally Posted by EddyTheDog

Maybe this?

http://stackoverflow.com/questions/2...all-statistics

Does anyone knwo if this will work?

BareBacked · 12-21-2012, 01:52 PM

bumperstien

BareBacked · 12-22-2012, 09:43 AM

Does no one use open x ?
I know some of you guys so my monthly traffic in a day. How do you stop your database going nuts.
I cant for the life of me work out how to trim it or archive the data in the admin.

nickutis · 12-22-2012, 10:18 AM

login to phpmyadmin, check which tables has most rows and simply empty them :D

That's what I was doing, though it deletes statistics completely

12-21-2012, 10:06 AM	#1
BareBacked Confirmed User Join Date: Feb 2007 Location: www.BareBacked.com Posts: 3,685	how do you delete openx history? I have an install with a 10 gig mysql . How can I remove all the old data ? __________________ NEW SITE PAYING $30 for a $1 TRIAL Selfies

12-21-2012, 10:08 AM	#2
EddyTheDog Just Doing My Own Thing Industry Role: Join Date: Jan 2011 Location: London, Spain, New Zealand, GFY - Not Croydon... Posts: 25,040	If you want get rid of ALL the data just re-install. Not sure if there is a way of just trimming the database. __________________ - Chaturbate Script - https://gfy.com/fucking-around-and-b...er-issues.html - Now supports White Labels

12-21-2012, 10:12 AM	#3
BareBacked Confirmed User Join Date: Feb 2007 Location: www.BareBacked.com Posts: 3,685	I dont wnat to get rid of all the banners zones etc just the clicks logs and huge files __________________ NEW SITE PAYING $30 for a $1 TRIAL Selfies

12-21-2012, 01:52 PM	#6
BareBacked Confirmed User Join Date: Feb 2007 Location: www.BareBacked.com Posts: 3,685	bumperstien __________________ NEW SITE PAYING $30 for a $1 TRIAL Selfies

12-22-2012, 09:43 AM	#7
BareBacked Confirmed User Join Date: Feb 2007 Location: www.BareBacked.com Posts: 3,685	Does no one use open x ? I know some of you guys so my monthly traffic in a day. How do you stop your database going nuts. I cant for the life of me work out how to trim it or archive the data in the admin. __________________ NEW SITE PAYING $30 for a $1 TRIAL Selfies

12-22-2012, 10:18 AM	#8
nickutis Confirmed User Join Date: Dec 2002 Posts: 719	login to phpmyadmin, check which tables has most rows and simply empty them :D That's what I was doing, though it deletes statistics completely