wordpress should support production - staging DB export/import flow

[OriHoch]

Midburn wordpress (serving https://midburn.org/) has a setup which combines code and DB making it hard to make changes, for example - changes by one developer might override changes by another developer

to solve this we need staging wordpress environment and a flow which will allows wordpress developers easy way to test on staging and deploy to production

this is the flow (actor is wordpress developer)-

• initiate a wordpress_update_staging command (e.g. via midburn k8s chatops, but any other way is fine)
  • creates a (private, secure) SQL dump of production DB
  • update wordpress staging environment with this SQL file
  • prevent running this command again until the wordpress_deploy_production command is run (see below)
• make changes to code or DB and test on staging wordpress
• when done,initiate a wordpress_deploy_production command
  • updates the staging DB or code to production (need to determine exactly what's needed here - how it should be "merged")