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

Data refresh for network database #1022

Closed
kdahlquist opened this issue Feb 22, 2023 · 3 comments
Closed

Data refresh for network database #1022

kdahlquist opened this issue Feb 22, 2023 · 3 comments

Comments

@kdahlquist
Copy link
Collaborator

Let's do a data refresh on the network database since the database was created 2023-03-07.

We are going to preserve the old data for reproducibility. This will be done once the database names are changed and when everyone has to load the data again.

@Onariaginosa
Copy link
Collaborator

I tested this on my local database and it worked. Will do so on the production database, once create copies of the database with the appropriate naming scheme as mentioned in #1020

@Onariaginosa
Copy link
Collaborator

I dumped the existing database from production and changed the schema names in the dump file. I then loaded them into my local database to test whether it would work properly without altering the existing schemas. Once that worked I loaded the dumped data with the proper schema names into the production database. I then tested the updating scripts on the dumped data in my local database. It worked as expected. I then updated the production database with the new network and it appears to have worked. I updated the documentation for these scripts and a pr is incoming.

@kdahlquist
Copy link
Collaborator Author

confirmed on beta 6.0.7

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

No branches or pull requests

2 participants