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.