[R] RMySQL on Mac OS 10.4

[Ryan Hafen]

I have been having trouble getting RMySQL to work on Mac OS 10.4.  It  
was working fine for me about a year ago but I didn't touch it for a  
while and several upgrades of R, MySQL, and OS X later, it is not  
working.

I first had the problem that others have been having getting the  
error discussed in https://stat.ethz.ch/pipermail/r-sig-mac/2005- 
November/002435.html saying that "RS-DBI driver warning: (MySQL  
mismatch between compiled version 4.0.24 and runtime version 4.1.14)".

I was able to get this error message to disappear by compiling MySQL  
with gcc 3.3, and now I can connect to my database and run queries,  
but when I try to use dbWriteTable, I get this error:

 > dbWriteTable(con, "test", rnorm(100))
Error in .class1(object) : no direct or inherited method for function  
'dbWriteTable' for this call

For more info, I am running OS X 10.4.6, R 2.2.1, I have compiled  
RMySQL from source version 0.5-7, and I'm running MySQL 4.1.19.

I have no idea what this error means and I have not found anything  
about it anywhere else in the help files.  If anyone knows what I can  
do to fix this, I would really really appreciate it.