Re: [R] Install RMySQL with R 2.4.0

From: Joe Byers <>
Date: Thu 04 Jan 2007 - 19:06:18 GMT


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

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 in RMySQL and 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 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 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
> ______________________________________________
> mailing list
> PLEASE do read the posting guide
> and provide commented, minimal, self-contained, reproducible code.

______________________________________________ mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Fri Jan 05 06:10:36 2007

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.1.8, at Wed 31 Jan 2007 - 02:30:25 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.