Big picture: Efficiently backup my Wordpress database. Then restore Wordpress Core + Extensions (Themes, Plugins) as exactly as possible in an automated fashion.

1. In this scenario I back up my Media Library by other means (rsync or CDN). What remains:
2. Backup the database (already know how to do that).
   • Note: That database already contains a list of all plugins (in their exact states) in the table wp_options in the various *_plugins rows.
   • That alone should make a convenient automatic re-installation of all themes and plugins possible.
   • It's a pity that there is yet no wp-cli command making use of this. Big user experience potential!
   • Proposing to make that possible with:
     → wp plugin install: Accepts also path to full or partial database backup .sql (.zip) extension-command#345
3. Source Code: Wordpress Core + Themes + Plugins:
   • Backing up up those generic source code files is a waste as they anyhow exist in public online repositories.
   • But in addition to step 2, I want to backup a list of installed plugins, like various Unix package managers allow that.
     • To keep that extension-list (CSV, JSON, …) for documentation purposes and for automated re-installation.
   • This is already possible with wp plugin list.
     • But currently does not keep track of whether auto-updates for a particular plugin are enabled or disabled.
       • In a few cases I keep a plugin frozen at a particular version on purpose.
       • On automatic restore those plugins should keep that setting.
     • Proposing to improve this with:
       → Include additional column (field) "auto-updates" which can be on or off extension-command#344