WordPress Theme Options Table

Theme settings are stored in the wp_options table in the following fields:

theme_mods_

option_name = theme_mods_[theme_name]

option_value = theme dependent on settings

If settings have been configured for a theme they will be stored in the theme_mods_theme_name under option_name.

If you have a copy of a theme and want to retain the settings you can copy and paste the option_value.

current_theme

option_name = current_theme

option_value = Theme Name

The currently selected field is identified by the current_theme and the option_value will be the theme name as specified in the themes style.css file under Theme Name: xxx.