golffinder Posted March 11, 2014 Report Share Posted March 11, 2014 Hi, we have a huge table in the openx source and thought I would ask you guys if you know how to solve it or if it can be solved. We dont want to jst go delete stuff incase at this stage? mysql> select TABLE_ROWS from information_schema.tables where TABLE_SCHEMA = 'XXXXXXX_openx' and TABLE_NAME = 'ox_data_summary_ad_zone_assoc'; +------------+ | TABLE_ROWS | +------------+ | 56,936,233 | +------------+ Quote Link to comment Share on other sites More sharing options...
Eliza0406 Posted March 11, 2014 Report Share Posted March 11, 2014 HI, You can just write a script to delete the data from ox_data_summary_ad_zone_assoc by specifying date(i.e Pass start and end date manually via url of the script page). Quote Link to comment Share on other sites More sharing options...
golffinder Posted March 11, 2014 Author Report Share Posted March 11, 2014 ok, but does this table also hold all the stats data, I don't want to get rid of that? Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.