uoacer/research-hub-db repository overview

⁠Research Hub DB

A docker image for the Research Hub⁠ database. This Docker image runs MySQL, seeds the database and automatically backs up the database daily.

MySQL and Cron are run via Supervisord. Cron runs a script that dumps the MySQL database into the /data/ folder, which you can mount onto the host filesystem.

⁠Running the database container locally

Follow the instructions for running the database container locally in Research Hub Deploy project⁠.

You should place the database spreadsheet in config/db/database.xlsx in the cloned Deploy project directory.

To build the database container:

./hubby build db

To run the database container:

./hubby up db

You can then examine the database using the MySQL client:

./hubby compose exec db bash
mysql -p

You can find the MySQL account password in the Deploy project⁠.

If you make changes to the spreadsheet, you will need to run the following commands in order for the database container to reseed with the changed data:

./hubby cleandb
./hubby up db

You will be prompted for your sudo password on the cleandb step.