Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

Restore deleted blog posts on production RDS #1381

Open
rachelekm opened this issue Apr 10, 2024 · 0 comments
Open

Restore deleted blog posts on production RDS #1381

rachelekm opened this issue Apr 10, 2024 · 0 comments
Assignees

Comments

@rachelekm
Copy link
Collaborator

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.

@rachelekm rachelekm self-assigned this Apr 10, 2024
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant