将RMySQL程序包添加到R中失败(在Windows上)? [英] adding RMySQL package to R fails (on Windows)?
本文介绍了将RMySQL程序包添加到R中失败(在Windows上)?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
我不知道为什么我的RMySQL软件包无法安装-这就是我得到的:
I can't figure out why my RMySQL package won't install - here's what I get:
> install.packages('RMySQL',type='source')
trying URL 'http://cran.mirrors.hoobly.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' ...
ERROR: configuration failed for package 'RMySQL'
* removing 'C:/PROGRA~1/R/R-212~1.0/library/RMySQL'
The downloaded packages are in '(foo)'
Warning message:
In install.packages("RMySQL", type = "source") : installation of package 'RMySQL' had non-zero exit status
我认为MySQL安装没有问题,因为正确的值似乎在注册表中:
I don't think it's a problem with the MySQL install, as the right values seem to be in the registry:
> Sys.getenv('MYSQL_HOME')
MYSQL_HOME "C:/PROGRA~1/MySQL/MYSQLS~1.1/"
> readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
$`MySQL Server 5.1`
$`MySQL Server 5.1`$DataLocation
[1] "C:\\Documents and Settings\\All Users\\Application Data\\MySQL\\MySQL Server 5.1\\"
$`MySQL Server 5.1`$FoundExistingDataDir
[1] "0"
$`MySQL Server 5.1`$Location
[1] "C:\\Program Files\\MySQL\\MySQL Server 5.1\\"
$`MySQL Server 5.1`$Version
[1] "5.1.54"
困惑.任何帮助将不胜感激!
Puzzled. Any help would be greatly appreciated!
推荐答案
The basic process is described here, but there are several hints, So I will describe the whole solution (please change the R version and paths if needed):
- 从此处 安装最新的RTools
- 安装MySQL或mysql的头文件和库文件
- 创建或编辑文件
C:\Program Files\R\R-2.12.1\etc\Renviron.site
并添加MYSQL_HOME=C:/mysql
(mysql文件的路径)之类的行 - 将libmysql.lib从mysql/lib复制到mysql/lib/opt以满足依赖关系.
- 将libmysql.dll复制到
C:\Program Files\R\R-2.12.1\bin
或windows/system32
目录. - 运行
install.packages('RMySQL',type='source')
并等待编译结束.
- Install latest RTools from here
- install MySQL or header and library files of mysql
- create or edit file
C:\Program Files\R\R-2.12.1\etc\Renviron.site
and add line likeMYSQL_HOME=C:/mysql
(path to your mysql files) - copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies.
- copy libmysql.dll to
C:\Program Files\R\R-2.12.1\bin
or towindows/system32
directory. - run
install.packages('RMySQL',type='source')
and wait while compilation will end.
这在Windows 7 64位版本上对我有效,因此32位版本应该没有问题
This worked for me on Windows 7 64 bit, so there should be no problems with 32 bit versions
最初在此处发布(类似问题).
Initialy posted here (similar question).
这篇关于将RMySQL程序包添加到R中失败(在Windows上)?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文