Title: Plugin: Advertising Manager – Database Tables
Last modified: August 19, 2016

---

# Plugin: Advertising Manager – Database Tables

 *  [andysim](https://wordpress.org/support/users/andysim/)
 * (@andysim)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/plugin-advertising-manager-database-tables/)
 * I’ve got this plug in installed on a couple of my blogs, but given how long it
   takes to set all the ads up, I was wondering if there was a quick way of copying
   the data from one blog to another?
 * presumably the ads are all stored in the wp database, so i should be able to 
   export/import – but I’ve looked and can’t see them – anyone got any ideas?
 * I’ve tried looking on the openx website, but that seems to have been down for
   the last few days.
 * Andy

Viewing 2 replies - 1 through 2 (of 2 total)

 *  Thread Starter [andysim](https://wordpress.org/support/users/andysim/)
 * (@andysim)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/plugin-advertising-manager-database-tables/#post-1414502)
 * why is it you always figure it out after you post on forums for help!
 * If any one is interested – the ads are added into the wp_options (or wp_X_options
   if you’re using MU)
 * to import them over, I exported the wp_options table from the blog with the ads
   already set up and opened it in a text editor. I then looked for the line that
   contained plugin_advman and copied this line of code to the clipboard.
 * Switch to the new blog’s phpmyadmin and look for the same line in the wp_options
   table and make a note of the value in the ‘option id’ field, then drop this entry
 * in phpmyadmin on the blog i wanted to copy them to, i went back to the wp_options
   table and hit the sql tab. I pasted in the code from the export and changed the
   option id to the same as the one i’d just dropped from the table and hit go..
   few seconds later all done and my ads are showing up on the 2nd blog
 * hope that makes sense..
 * andy
 * The
 *  [switzer](https://wordpress.org/support/users/switzer/)
 * (@switzer)
 * [16 years, 3 months ago](https://wordpress.org/support/topic/plugin-advertising-manager-database-tables/#post-1414730)
 * andysim:
 * Great to hear you figured it out. Thanks for the tips
 * Scott

Viewing 2 replies - 1 through 2 (of 2 total)

The topic ‘Plugin: Advertising Manager – Database Tables’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)

 * 2 replies
 * 2 participants
 * Last reply from: [switzer](https://wordpress.org/support/users/switzer/)
 * Last activity: [16 years, 3 months ago](https://wordpress.org/support/topic/plugin-advertising-manager-database-tables/#post-1414730)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics