How to export all settings to take Ad Inserter to another web server

You can copy settings from the database.
The settings are stored in ad_inserter option in wp_options table.

How can export only “ad_inserter” from the “wp_options” table, and the restore only “ad_inserter” to another database?

Thanks,

Go to PhpMyAdmin in your hosting control panel, open the database of the old website, go to wp_options table, find ad_inserter option name, click on Edit and copy contents.

Then paste this content in the new database into the same option. Just make sure Ad Inserter is installed and the (empty) settings are saved so the option is created.

Once you paste and save new option value you’ll have the same settings for Ad Inserter in the new website.

@spacetime the server doesn’t have phpmyadmin, how to export and import these settings using mysql command lines.

Thank you so much.

Then simply install it.

I have no experience with mysql commands.
Maybe you can ask your hosting comapny for help.

But using PhpMyAdmin is far more simple for such tasks.

@spacetime OK, so installed phpmyadmin, copied the content from the ad_inserter ad_inserter_extract to the new rows in the new database, I refreshed the wordpress site, and the no settings show up on Ad Inserter plugin.

• This reply was modified 4 years, 9 months ago by wpmhweb.

No, you need to copy ad_inserter option from wp_options table.

@spacetime I think you mean the ad_inserter_extract, because all the custom settings are in the ad_inserter. I tried copying only the row that includes all the settings (ad_inserter) too and the plugin doesn’t picked up the settings.

However, the only way it works for me was exporting the settings to .sql file. Open the exported file, copying the INSERT INTO statement with the data, and running the sql command in the SQL tab of phpmyadmin.

• This reply was modified 4 years, 9 months ago by wpmhweb.