yes. i am running MySQL 5.0.15 and R 2.2.0. everything appears to work fine now, although I've found that MySQL "goes away" (I believe that is close to the syntax from the R error message--can't replicate right now) if I don't call to it for a long period of time. not sure whether that is a bug or security measure.
On Dec 5, 2005, at 12:53 PM, Paul Shannon wrote: > Simon asks: > >> can you, please, supply us with some critical details such as how you >> installed and/or compiled RMySQL and whether you have a custom or >> CRAN version of R? > > Gene offered: > >> I just had (and posted about) the exact same error message. I found >> it went away after updating Xcode to 2.2. I also made a change to >> SHLIB (though I don't know if that made a difference), which I can >> look up when I am at my other computer. > > and Franklin said: > >> hi. you may have found my postings on this topic in the archives >> from about a month back. i had somewhat different problems with >> RMySQL, but all my problems were resolved after I re-installed >> MySQL from source and RMySQL from source (both with default >> compiler 3.3). > > I used R 2.1.1, installed from the CRAN binary. RMySQL I built > from source, version 0.5-5, > on top of XML (0.97-8) and DBI (0.1-9). > > I did all this at home, on OSX 10.4.3, but only after installing > the latest > MySQL binary -- version 5.0.16-standard. > > Repeating the installation at work, using MySQSL 4.1.10-max, > everything worked fine. > I'm afraid to upgrade MySQL from 4.1. to 5.0. > > Has anyone else had any luck with MySQL 5.0 and RMySQL? > > Thanks! > > - Paul > > _______________________________________________ > 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
