WordPress.org

Ready to get started?Download WordPress

Forums

Copy widget settings between databases (1 post)

  1. relaxedguy
    Member
    Posted 3 years ago #

    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.

    Dave

Topic Closed

This topic has been closed to new replies.

About this Topic