I'm looking into setting up a development -> staging -> production workflow, and the biggest issue so far is figuring out how to sync the databases.
To this end, I'm trying to figure out exactly which actions will affect the filesystem, the database, or both. Here's how I think it works. Please correct me where I'm wrong, and let me know if my questionable answers are right!
- Registering a new user - database
- Adding a post or comment - database
- Changing to a new theme - database?
- Changing a theme's settings - database
- Installing or removing a plugin - filesystem
- Activating, or deactivating a plugin - filesystem
- Updating a plugin - filesystem and database? (DB structure may change?)
- Changing a plugin's settings - database
- Uploading media - filesystem and database?
- Editing custom files not included in a theme or plugin - filesystem
- Upgrading Wordpress - filesystem?