Install MySQL

From Knowledge

This works on Snow Leopard. Use Macports. And consult HowTo MAMP.

sudo port install mysql5-server
sudo -u mysql mysql_install_db5
sudo chown -R mysql:mysql /opt/local/var/db/mysql5/ 
sudo chown -R mysql:mysql /opt/local/var/run/mysql5/ 
sudo chown -R mysql:mysql /opt/local/var/log/mysql5/
sudo port load mysql5-server
ps -ax | grep mysql
mysqladmin5 -u root -p password <new-password>

Not sure if you still need to adjust these passwords. But now you do want to install the baseball database.

create database baseball;
use baseball;
source ~/Desktop/BDB-sql-2008-03-28.sql;
source ~/Documents/2000/2000s_Retrosheet.sql

Compile and install the UDFs. Put them in the /opt/local/lib/mysql5/mysql/plugin

cd ~/Documents/mysql-udf_patched/
for o in *.cc; do g++ -o $o.so -shared -I/opt/local/include/mysql5/mysql $o; done
for f in *.cc.so; do j=`echo $f | sed 's/\.cc//g'`; mv $f $j; done
sudo mv *.so /opt/local/lib/mysql5/mysql/plugin
mysql -u root -p
CREATE AGGREGATE FUNCTION median RETURNS  REAL SONAME 'udf_median.so';
CREATE AGGREGATE FUNCTION correlation RETURNS REAL SONAME 'udf_correlation.so';
CREATE AGGREGATE FUNCTION kurtosis RETURNS REAL SONAME 'udf_kurtosis.so';
CREATE AGGREGATE FUNCTION intercept RETURNS REAL SONAME 'udf_intercept.so';
CREATE FUNCTION faculty RETURNS REAL SONAME 'udf_faculty.so';
CREATE AGGREGATE FUNCTION geomean RETURNS REAL SONAME 'udf_geomean.so';
CREATE AGGREGATE FUNCTION skewness RETURNS REAL SONAME 'udf_skewness.so';
CREATE AGGREGATE FUNCTION slope RETURNS REAL SONAME 'udf_slope.so';
CREATE AGGREGATE FUNCTION weightedavg RETURNS REAL SONAME 'udf_weightedavg.so';