VandySingh Posted October 7, 2014 Report Share Posted October 7, 2014 I installed revive Adserver in our stage and production environment. I created campaigns in our stage environment and it's working great. Now I need to move all the campaigns from stage to production. Does anybody have any idea how to accomplish this. I don't want to create campaigns again in the production. Quote Link to comment Share on other sites More sharing options...
Snoork Hosting Posted October 10, 2014 Report Share Posted October 10, 2014 I do not believe there is an easy way to copy specific data over from one server to another. You would most likely have to extract that specific campaign for MySQL database and then import it back into your other server. I wouldn't advise it thought. It's best to setup the campaigns again or transfer the entire database over. Quote Link to comment Share on other sites More sharing options...
Eliza0406 Posted October 16, 2014 Report Share Posted October 16, 2014 Hi, Yes,You have to export the data manually with associated tables from your stage adserver to production server. Quote Link to comment Share on other sites More sharing options...
VandySingh Posted October 16, 2014 Author Report Share Posted October 16, 2014 I am using MySQLDump to copy the whole database to a file on stage server. and on production server, I am updating the database from the dump file. But my problem is that the statistics also gets updated. I don't want to change the statistics. Does anyone have any idea which are the tables related to statistics that I can ignore when I am copying the stage database to the dump file. So far I ignored these table while copying database to a file but I see the statistics are still effected Rv_statistics_Vast RV_Target_Stats RV_Trackers RV_Tracker_Append RV_log_maintainnace_Statisitcs Please help. Quote Link to comment Share on other sites More sharing options...
Eliza0406 Posted October 17, 2014 Report Share Posted October 17, 2014 Hi VandySingh, Try copying by ignoring "hourly" table. 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.