Title: Plugins and SQL tables
Last modified: August 5, 2020

---

# Plugins and SQL tables

 *  [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * (@eyeghoti)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/)
 * Do all plugin settings reside in the SQL tables for the respective plugins?
 * So if we have a full backup of the SQL database, and the /plugins/ folder is 
   unchanged, can we revert to a previous setting for a plugin by copying the backed
   up version of its table to the current SQL database?
    (Presumably there’s no 
   garuntee this will work if the plugin has been updated as well?)

Viewing 6 replies - 1 through 6 (of 6 total)

 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/#post-13213397)
 * As a general rule, yes. Generally, the options are in the wp_options table, not
   plugin-specific tables. So, reverting wp_options may affect all sorts of things.
 * You might have to pick out specific rows from that table rather than restore 
   the entire table.
 *  Thread Starter [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * (@eyeghoti)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/#post-13213449)
 * Thanks. A huge help.
    Probably a dumba*** question, but what’s typically in the
   plugins tables then?
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/#post-13213553)
 * Depends on the plugin.
 *  Thread Starter [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * (@eyeghoti)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/#post-13213775)
 * 2nd dumba*** question:
    Does it make sense to restore the plugin’s table AND 
   the relevant row from the wp_options table?
 *  Moderator [Steven Stern (sterndata)](https://wordpress.org/support/users/sterndata/)
 * (@sterndata)
 * Volunteer Forum Moderator
 * [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/#post-13213909)
 * Once again, it depends on the plugin. For the best info, ask the plugin’s developer(
   s).
 *  Thread Starter [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * (@eyeghoti)
 * [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/#post-13213915)
 * Thanks.

Viewing 6 replies - 1 through 6 (of 6 total)

The topic ‘Plugins and SQL tables’ is closed to new replies.

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 6 replies
 * 2 participants
 * Last reply from: [eyeghoti](https://wordpress.org/support/users/eyeghoti/)
 * Last activity: [5 years, 9 months ago](https://wordpress.org/support/topic/plugins-and-sql-tables/#post-13213915)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics