Frank, While I was replying to you our IT guys sent me a message as said I could connect. I have posted the RMySQL zip file at
http://bus.cba.utulsa.edu/byersj/Research.asp Good luck to all Joe Frank McCown wrote: > Joe Byers wrote: >> All, >> >> After staring at this error message for an hour or so yesterday and this >> morning. I decided to try something else. Low and behold trying to >> build the package in cygwin causes R to try and build under linux/unix >> not windows. I went to the command prompt and was able to build the >> package. >> >> Download the RMySQL...tar.gz file and unzip somewhere like drive:/projects >> >> Several notes >> 1. make sure you have mysql directories on your computer somewhere with >> the subdirs of include, bin, and lib. You can just copy these from >> you actual server unless you want to install them. I used d:/mysql/... >> 2. Modify configure.win in RMySQL and Makevars.win ins RMySQL/src to >> have the mysql directories from (1) >> 3. Copy and paste this script to a batch file and execute >> ************** >> Rem build without --docs=normal tries to build chm help on windows this >> bombs >> Rem if a zip program not installed the zip file will not be built >> Rem go find the temp directory where R built the package and copy to >> ../R/library >> Rem temp directory will look something like C:\Temp\Rinst32098657\RMySQL >> >> Rem if R bin directory in the path this will run otherwise add the >> drive:\Dir1\R\bin to the command >> Rcmd build --binary \projects\RMySQL --docs=normal >> *********************** >> 4. Note that I have --docs=normal in the command line. This is needed to >> get the package built. Windows packages now default to chm files and >> RMySQL does not have any windows chm help files. All txt, html, and >> latex help are built with this option. >> 5. I am not sure where the RMySQL...zip file is stored, I think in >> ...R\Bin. I just copied the files from the temp\RinstXXXXXX\to the >> ...\R\library to install. >> >> This may or may not work for you, it did for me. >> >> I will try and update my website www.cba.utulsa.edu/byersj Research and >> Analytics section to include a link to the RMySQL zip file for others to >> download. >> >> Good Luck >> Joe > > > Joe, > > Thanks for telling us how you got RMySQL installed. Would you mind > posting the dll files so the rest of us wouldn't have to recompile anything? > > Thanks, > Frank > > ______________________________________________ > 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 > and provide commented, minimal, self-contained, reproducible code. > ______________________________________________ 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 and provide commented, minimal, self-contained, reproducible code.
