Can you export and import Custom Sidebars?

Hi @smellcoffee,

I hope you are well today and thank you for your question.

You can export your custom sidebars settings by exporting the .sql file from your old WordPress database selecting “cs_sidebars” and “cs_modifiable” options from the wp_options table where wp_ is a WordPress table prefix.

Import the custom sidebars settings by importing this generated sql file containing “cs_sidebars” and “cs_modifiable” options in your new WordPress database.

To import / export widgets from your old site to new site try using the following plugin.

https://ww.wp.xz.cn/plugins/widget-importer-exporter/

Best Regards,
WPMU DEV

You are most welcome, if I can be of any further assistance please don’t hesitate to ask 🙂

Hi Floortje,

Thanks for posting on the forums.

I think you are exporting and importing whole wp_options table, you don’t need to export/ import whole wp_options table for exporting / importing custom sidebars settings.

To import / export only the Custom Sidebars settings execute the following sql query in your PHPMyAdmin sql executer.

SELECT * FROM<code>wp_options</code>WHERE option_name = "cs_sidebars" or option_name = "cs_modifiable";

Then on the generated results page select all the two found rows by clicking on the “Check All” text and export it by clicking on the “Export” text as described in the following reply.

http://serverfault.com/a/300342

If by any chance according to the configuration of your PHPMyAdmin the exported sql file contains the wp_options table creation code as following

CREATE TABLE 'wp_options' (

then before importing just change the above code in the generated sql file as below so that when importing it won’t generate “Table ‘wp_options’ already exists” error message

CREATE TABLE IF NOT EXISTS 'wp_options' (

Cheers,
WPMU DEV