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.