
<h1>
Get your own copy of the HPR database</h1>
<p>
<br>
</p>
<p>
reset_hpr.sh</p>
<p>
<br>
</p>
<pre class="ql-syntax" spellcheck="false">
systemctl start mariadb
curl https://hackerpublicradio.org/hpr.sql &gt; hpr.sql 
mariadb -e 'drop database hpr_hpr'
mariadb -e 'create database hpr_hpr'
mariadb hpr_hpr &lt; hpr.sql 
mariadb -e 'select  count(*) from eps' hpr_hpr
mariadb -e 'select * from comments where comment_author_name="Torin Doyle" \G' hpr_hpr
</pre>
<p>
<br>
</p>


