HPR4403: How to get your very own copy of the HPR database

Get your own copy of the HPR database

reset_hpr.sh

systemctl start mariadb
curl https://hackerpublicradio.org/hpr.sql > hpr.sql
mariadb -e 'drop database hpr_hpr'
mariadb -e 'create database hpr_hpr'
mariadb hpr_hpr < hpr.sql
mariadb -e 'select count(*) from eps' hpr_hpr
mariadb -e 'select * from comments where comment_author_name="Torin Doyle" G' hpr_hpr