owid-grapher icon indicating copy to clipboard operation
owid-grapher copied to clipboard

Add a simple and flexible command for refreshing the MySQL database from live

Open larsyencken opened this issue 2 years ago • 2 comments

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.

larsyencken avatar Apr 12 '22 13:04 larsyencken

Marking it as "important" since @mlbrgl needs hit for his workflow, though if it becomes urgent he may try a fix himself.

larsyencken avatar Apr 12 '22 14:04 larsyencken

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

danielgavrilov avatar Jul 13 '22 11:07 danielgavrilov