Jump to content

Grabbing Data From The Old Database

Recommended Posts

Hello guys


I got many problems because of upgrading from openx to adserver. 


Every upgrade I have to work things through.


So I decided to do a clean install.


Is there any way to grab advertisers, campaigns, banners, websites and zones from the old database?


Thanks! Please help!!!!

Link to comment
Share on other sites

According to the -> upgrade docs. <- you may be able to use the database tools to assist you. I havn't had the pleasure of migrating wildly different Adserver database versions, and it probably won't be a single command, but it's worth looking into.

1. Copying the database
As explained in detail above, the upgrade process involves making a copy of your production database into a newly created database and then to run the upgrade on this new database.
If you’re not comfortable with command line statements, you might be able to use a tool like phpMyAdmin to copy all of your tables from the existing database ‘revive_adserver_abc’ into the new database ‘revive_adserver_xyz’.
However, it is often faster to use a few command line statements to export the data from the existing database and then to import it into the new database. If you don’t know how, ask a colleague, team member, or outside expert for help.
Here is a template for the command line statements.
To export data from the existing database into a text file:Quotemysqldump -uUSER -pPASSWORD OLDDATABASE –skip-lock-tables > FILE.sqlTo import data from this text file into the new database:Quotemysql -uUSER -pPASSWORD NEWDATABASE < FILE.sqlYou’ll have to replace the USER, PASSWORD, OLDDATABASE and NEWDATABASE placeholders with the actual names and values.
Whatever way of copying the data you use, always make sure that you’ve got a copy of all the tables of your existing database. You can do this by comparing the list of tables of both databases.
Link to comment
Share on other sites

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.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

  • Create New...