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

[Uwe Ligges]

Well, two comments:

1. you bought a commercial version of R from Revolution Analytics, hence 
you probably want to rely on the Revolution service?


2. Nobody looked at the error message you got, let me cite the relevant 
two lines:

 >>> checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.0
 >>> test: Files/MySQL/MySQL: unknown operand

This shows you have problems with the blanks in the path name.
Either you forgot to quote the path when setting the environment 
variable or RMySQL the package maintainer has not assumed blanks in the 
path.
I'd suggest to quote or to use thew 8.3 file name convention in order to 
workaround.

Best,
Uwe Ligges





On 13.11.2010 14:52, Spencer Graves wrote:
> 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.