WordPress / wporg-repo-tools

6 stars 4 forks source link

Standardize & automate production content import #1

Open iandunn opened 3 years ago

iandunn commented 3 years ago

https://github.com/WordPress/wporg-news-2021/pull/10 describes how to manually import db content. It'd be nice to have a standard and automated approach for that across all repos.

wp hammer might be useful for that. Example:

https://github.com/iandunn/regolith/blob/aec98edaacb12655d9947fe15379d42eb67a2c44/bin/sync-production-content.sh#L133

That Regolith script has some MySQL queries and other functions that may be useful too, but we also have some limitations that prevent the most convenient features of it.

wp-hammer will also miss some essential PII, like comment emails.

So, we may not be able to automate all of it, but it might be worth exploring the next time we need to import/update content.