Questions about Git and WordPress [duplicate]

This is not specifically a GIT question so much as a development workflow question (GIT vs. SVN will produce similar WordPress workflows given the details you provided).

If the changes the client wants to make don’t depend directly on specific DATA then you don’t need to sync your PROD data down to your local environment for every change. For example, you can change the styles of your home page without relying on specific posts in the database.

The same goes for images stored in the media library. If the client just wants to see images aligned or styled in a specific way then you can demonstrate those changes with FPO graphics in your LOCAL or STAGING environments without a sync.

Here are a few things to consider when defining a workflow:

  • You can sync a clean copy of PROD or STAGING down to your LOCAL environment any time. Most of the time your local data will be disposable.
  • You should only sync from LOCAL up to STAGING (never up to PROD) in case your client needs to review changes you’ve made locally that rely on specific data being present in the DB.
  • Your PROD media library should be your “clean” set. Try to avoid loading images into PROD for testing purposes. Use LOCAL and STAGING for that.
  • If you can spring for a CDN that will ease a lot of burden of moving media assets around all over the place. Most cacheing plugins will reference your CDN assets via absolute URL regardless of your environment.
  • If you don’t have a CDN in place, you should version control your media assets to make it easier to move them around. A CDN is a faster/cleaner solution but many people will still add version control anyway (for peace of mind).
  • Run backups on your PROD data often so you always have a recent recovery point. This is especially true of your DB and any assets not currently under version control.

A lot of this is more general advice to consider when defining a workflow that works for you. I hope the advice is helpful.