[R] RMySQL on Windows 2008 64 Bit -Help!

[Spencer Graves]

Hello:


       I suggest try R-SIG-DB email list.  They focus specifically on 
databases, and you might get a better response there.


       Sorry I can't help more.
       Spencer


On 11/13/2010 1:12 AM, Santosh Srinivas wrote:
> I could do that but will have to change all my code.
>
> It would be great if I could get RMySQL on the 64 bit machine.
>
> -----Original Message-----
> From: Ajay Ohri [mailto:ohri2007 at gmail.com]
> Sent: 13 November 2010 14:13
> To: Santosh Srinivas
> Cc: r-help at r-project.org
> Subject: Re: [R] RMySQL on Windows 2008 64 Bit -Help!
>
> did you try the RODBC package as well.
>
> Regards
>
> Ajay
>
> Websites-
> http://decisionstats.com
> http://dudeofdata.com
>
>
> Linkedin- www.linkedin.com/in/ajayohri
>
>
>
>
>
> On Sat, Nov 13, 2010 at 9:22 AM, Santosh Srinivas
> <santosh.srinivas at gmail.com>  wrote:
>> Dear Group,
>>
>> I'm having lots of problems getting RMySQL on a 64 bit machine. I followed
>> all instructions available but couldn't get it working yet! Please help.
>> See the output below.
>>
>> I did a install of RMySQL binary from the revolution cran source. It seems
>> to have unpacked fine but gives this error when I call RMySQL
>> Error: package 'RMySQL' is not installed for 'arch=x64'
>>
>>
>> I set this environment variable on the windows path
>>> Sys.getenv('MYSQL_HOME')
>>                                MYSQL_HOME
>> "C:/Program Files/MySQL/MySQL Server 5.0"
>>
>>>   install.packages('RMySQL',type='source')
>> trying URL
>> 'http://cran.revolutionanalytics.com/src/contrib/RMySQL_0.7-5.tar.gz'
>> Content type 'application/x-gzip' length 160769 bytes (157 Kb)
>> opened URL
>> downloaded 157 Kb
>>
>> * installing *source* package 'RMySQL' ...
>> checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.0
>> test: Files/MySQL/MySQL: unknown operand
>> ERROR: configuration failed for package 'RMySQL'
>> * removing 'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL'
>> * restoring previous
>> 'C:/Revolution/Revo-4.0/RevoEnt64/R-2.11.1/library/RMySQL'
>>
>> The downloaded packages are in
>>
>>
> 'C:\Users\Administrator\AppData\Local\Temp\2\RtmpvGgrzb\downloaded_packages'
>> Warning message:
>> In install.packages("RMySQL", type = "source") :
>>   installation of package 'RMySQL' had non-zero exit status
>>> sessionInfo()
>> R version 2.11.1 (2010-05-31)
>> x86_64-pc-mingw32
>>
>> locale:
>> [1] LC_COLLATE=English_United States.1252  LC_CTYPE=English_United
>> States.1252    LC_MONETARY=English_United States.1252 LC_NUMERIC=C
>>
>> [5] LC_TIME=English_United States.1252
>>
>> attached base packages:
>> [1] stats     graphics  grDevices utils     datasets  methods   base
>>
>> other attached packages:
>> [1] Revobase_4.0.0   RevoScaleR_1.0-0 lattice_0.18-8
>>
>> loaded via a namespace (and not attached):
>> [1] grid_2.11.1  tools_2.11.1
>>
>> ______________________________________________
>> R-help at r-project.org 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 at r-project.org 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.
>
>


-- 
Spencer Graves, PE, PhD
President and Chief Operating Officer
Structure Inspection and Monitoring, Inc.
751 Emerson Ct.
San José, CA 95126
ph:  408-655-4567