owid-grapher
owid-grapher copied to clipboard
Add a simple and flexible command for refreshing the MySQL database from live
Problem
We already have scripts that refresh the grapher database fully, and refresh wordpress fully, and it all happens neatly when you are spinning up a new environment, but it would be helpful to have more control when updating your environment.
Proposal
Add Makefile
commands, or a devTools
script, that makes updating the database much easier. It should especially allow you to update just chart metadata, metadata + chart data, just wordpress, or everything.
Marking it as "important" since @mlbrgl needs hit for his workflow, though if it becomes urgent he may try a fix himself.
I also need it, and I imagine everyone else needs it at some point.
I had a look at adding a script but my bash + Docker knowledge isn't great and didn't know exactly how the current scripts work.
Instead for now I'm using this snippet from Pablo:
cd # to project folder
docker volume rm owid-grapher_mysql_data_public
rm -r ./tmp-downloads