[R] Install RMySQL with R 2.4.0

[Joe W. Byers]

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 at 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.
>