RServe on OSX Snow Leopard

I always seem to have some difficulty getting the Rserve component of the R stats library up and running on OSX.  Installing it via install.packages(“rserve”) from within R  appears to work but when running R CMD Rserve I usually get some sort of error like:

/Library/Frameworks/R.framework/Resources/bin/Rcmd: line 62: exec: Rserve: not found

Compiling from source using the download from http://rosuda.org/Rserve/ never seems to work with all sorts of C related horror.

However, the Rserve component actually was installed but it looks like the paths/links were not quite right.  Typing this:

R CMD /Library/Frameworks/R.framework/Resources/library/Rserve/libs/x86_64/Rserve.so

Got everything up and running. Doing this:

cp /Library/Frameworks/R.framework/Resources/library/Rserve/libs/x86_64/Rserve-bin.so /Library/Frameworks/R.framework/Resources/bin/Rserve

fixes it a bit more permanently

Obscure mysql bug number 1153 (08S01) (my packet’s too big)

Ok, here’s one you don’t see every day.

Importing a mysql dumpfile results in “ERROR 1153 (08S01) at line 265: Got a packet bigger than ‘max_allowed_packet’ bytes”

Errm.

Log in to a mysql console,

enter the magic commands:

set global net_buffer_length=1000000;

set global max_allowed_packet=1000000000;

Modify your import to include the command:

–max_allowed_packet=100M

so you have something like

mysql –max_allowed_packet=100M -u user -p db_name < dump.sql

Try again

Your mileage may vary ( do they say kilometerage elsewhere?) so increase the allowed sizes if you have to.