As part of work to remove old staff accounts, blog posts authored by those users were accidentally deleted on production. We want to recover all the deleted articles by authors Maya, Olivia and Erika -- updating their author to a valid admin user along the way. See slack discussion here.
We have snapshots of the production RDS instance that we can use to recover the articles, with two proposed plans: create a new, temporary RDS instance from a restored snapshot or export the snapshot to S3 where we can then download and install it locally.
Once a separate, restored database is up we can connect to query for all the blogs posts by Maya, Olivia and Erika and then create a SQL insert statement for adding them back in with an updated author on production.
As part of work to remove old staff accounts, blog posts authored by those users were accidentally deleted on production. We want to recover all the deleted articles by authors Maya, Olivia and Erika -- updating their author to a valid admin user along the way. See slack discussion here.
We have snapshots of the production RDS instance that we can use to recover the articles, with two proposed plans: create a new, temporary RDS instance from a restored snapshot or export the snapshot to S3 where we can then download and install it locally.
Once a separate, restored database is up we can connect to query for all the blogs posts by Maya, Olivia and Erika and then create a SQL insert statement for adding them back in with an updated author on production.