[R] RMySQL on Mac OS 10.4

From: Ryan Hafen <ryan.hafen_at_utah.edu>
Date: Tue 23 May 2006 - 12:40:54 EST

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.

R-help@stat.math.ethz.ch mailing list
https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html Received on Tue May 23 12:45:38 2006

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Tue 23 May 2006 - 14:10:31 EST.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.