# [R] Install RMySQL with R 2.4.0

Joe W. Byers ecjbosu at aol.com
Wed Jan 31 02:52:59 CET 2007

This is a test to get my new subscription upgraded.  forgive me.

thank you
Joe

Joe Byers wrote:
> All,
>
> I am glad all of you have benefited from the posting of the RMySQL 5-10
> zip file on my university website.  I am asking for some help from the
> group, I am leaving the university at the end of the semester and I need
> a place to post this file until I get settled in my new position.
> Anyone that can help me or us out with this. It would be greatly
> appreciated.
>
> Thank you
> 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.
>>>
>>>
>>> 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
>>>
>>> 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
>> and provide commented, minimal, self-contained, reproducible code.
>>
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help