Support » Plugins » Hacks » Copy widget settings between databases

  • I am looking for the definitive guide for copying wp_options widget-related rows from one database to another via phpmysql. I believe sidebars_widgets and widget_text are the two primary rows but there are a bunch of them in wp_options.

    What are the steps and the sql query to identify all relevant rows in phpmyadmin? I use LIKE to find a dozen or so “widget_*” rows, but how to export those rows to a text file that I can download and then import into another database? When I try to save file, it grabs the entire wp_options table.

    URL isn’t changing, not sure if something else is serialized that needs editing?

    Thanks, I can’t find this stuff anywhere.


  • The topic ‘Copy widget settings between databases’ is closed to new replies.