Title: Copy widget settings between databases
Last modified: August 20, 2016

---

# Copy widget settings between databases

 *  [relaxedguy](https://wordpress.org/support/users/relaxedguy/)
 * (@relaxedguy)
 * [14 years, 11 months ago](https://wordpress.org/support/topic/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.
 * Dave

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

## Tags

 * [widgets](https://wordpress.org/support/topic-tag/widgets/)
 * [wp_options](https://wordpress.org/support/topic-tag/wp_options/)

 * In: [Hacks](https://wordpress.org/support/forum/plugins-and-hacks/hacks/)
 * 0 replies
 * 1 participant
 * Last reply from: [relaxedguy](https://wordpress.org/support/users/relaxedguy/)
 * Last activity: [14 years, 11 months ago](https://wordpress.org/support/topic/copy-widget-settings-between-databases/)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics