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.
>
> --
> 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