A while back I posted a question about RMySQL not working because of a corrupted libmysqlclient.a library. I know at least one other person experienced the same problem. It was suggested that for compatibility with R 2.2.0 I needed to compile MySQL with gcc 3.3 (not gcc 4.0, as is the case with the MySQL binary). So:
(i) I installed MySQL from sources using gcc 3.3 as the c and c++ compiler (this was not as straightforward as I had hoped, and I had to experiment with a few different sets of configuration options -- if anyone is having a problem with this send me an email and I will dig up the configure call that worked for me). (ii) I reinstalled the RMySQL binary using the Package Installer feature in R.App. I am happy to report that it now works (meaning R doesn't crash when I issue, say, a dbWriteTable command; it successfully writes the table). However, even though R no longer crashes, I am still receiving the following message when I open the RMySQL package: "RS-DBI driver warning: (MySQL mismatch between compiled version 4.0.24 and runtime version 4.1.14)" The message is still confusing to me because I installed MySQL 5.0.15. Does anyone have a view on whether this warning will go away if I also install RMySQL and DBI from sources? On Oct 28, 2005, at 5:11 PM, Parlamis Franklin wrote: > >> >> Did you test the library *after* running ranlib and *before* >> reinstalling? That was the crucial point. >> > > Yes, I did. I should have been more clear. It still did not work, > so then I tried the re-install. > > I guess the only thing to do now is install MySQL from sources. I > will do so with gcc 3.3 set as default, as another user suggested, > let you know if it works. > > _______________________________________________ > R-SIG-Mac mailing list > [email protected] > https://stat.ethz.ch/mailman/listinfo/r-sig-mac _______________________________________________ R-SIG-Mac mailing list [email protected] https://stat.ethz.ch/mailman/listinfo/r-sig-mac
