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. ______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
