[R] Installing RMySQL -- 64-bit Windows 7

[David Winsemius]

On Mar 12, 2012, at 12:05 PM, Prof Brian Ripley wrote:

> On 12/03/2012 15:29, z2.0 wrote:
>> Trying to install RMySQL on 64-bit Windows 7.
>>
>> Using R-2.14.2 with Rtools214 and MySQL Server 5.5.
>>
>> Read through several step-by-steps of RMySQL source installation.
>>
>> Troubleshooting:
>>  - Copied libmysql.dll to R-2.14.2/bin AND R-2.14.2/bin/i386.
>>  - Copied libmysql.dll and libmysql.lib to MySQL Server 5.5\lib\opt.
>>  - Entered MYSQL_HOME=C:\Program Files\MySQL\MySQL Server 5.5 into
>> Renviron.site, saved to R\R-2.14.2\etc.
>>
>> My instances of common problems:
>>
>> Sys.getenv('MySQL_HOME') [1] "C:\Program Files\MySQL\MySQL Server  
>> 5.5\"
>>
>> install.packages('RMySQL', type = 'source') Installing  
>> package(s) ... ...
>> RS-DBI.c:1:0: sorry, unimplemented: 64-bit mode not compiled in make:
>> [RS-DBI.o] Error 1* ERROR: compilation failed for package  
>> 'RMySQL' ...
>>
>> I'm guessing my problem lies in the '64-bit mode...' message, but  
>> I'm not
>> sure.
>>
>> Thoughts?
>
> A. You failed to follow the instructions in 'R Installation and  
> Administration' about how to set your toolchain: it would be easier  
> to upgrade to Rtools215, for which R 2.14.2 is configured by default  
> (but can be told how to use Rtools214).
>
> B. Is libmysql.dll 32- or 64-bit?  Both variants exist, and you need  
> to match the version of R you use.

He also failed to inform the rhelp readership that this was earlier  
posted on StackOverflow:
http://stackoverflow.com/questions/9669660/rmysql-64-bit-os

-- 
David
>
>
>>
>> --
>> View this message in context: http://r.789695.n4.nabble.com/Installing-RMySQL-64-bit-Windows-7-tp4466352p4466352.html
>> Sent from the R help mailing list archive at Nabble.com.
>>
>> ______________________________________________
>> 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.
>
>
> -- 
> Brian D. Ripley,                  ripley at stats.ox.ac.uk
> Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
> University of Oxford,             Tel:  +44 1865 272861 (self)
> 1 South Parks Road,                     +44 1865 272866 (PA)
> Oxford OX1 3TG, UK                Fax:  +44 1865 272595
>
> ______________________________________________
> 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.

David Winsemius, MD
West Hartford, CT