Mysql 5.5的RMySQL安装问题 [英] RMySQL installation issue with Mysql 5.5
问题描述
我对R还是很陌生,但是我有一些编程经验. 我正在尝试在Windows 7上使用MySQL Workbench 5.2安装RMySQL,并且不断出现相同的错误.我已经检查了不同的步骤,但继续陷入困境:
http://vhaguiar.wordpress.com/2011/06/06/r-how-to-install-rmysql-in-windows-7-with-mysql-5-5/
http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL
MySQL已启动并运行,我已经移动了libmysql.lib和libmysql.dll,但是我一直遇到以下错误.我想我看不出问题的实质.你有什么建议吗?
install.packages("RMySQL", type="source")
--- Please select a CRAN mirror for use in this session ---
provo con l'URL 'http://cran.rakanu.com/src/contrib/RMySQL_0.8-0.tar.gz'
Content type 'application/x-gzip' length 160735 bytes (156 Kb)
URL aperto
downloaded 156 Kb
** installing *source* package 'RMySQL' ...
ERROR: configuration failed for package 'RMySQL'
* removing 'C:/Program Files/R/R-2.13.2/library/RMySQL'
The downloaded packages are in
‘C:\Users\Matteo\AppData\Local\Temp\RtmpYHjzuR\downloaded_packages’
Warning messages:
1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/i386/R CMD INSTALL -l "C:/Program Files/R/R-2.13.2/library" C:\Users\Matteo\AppData\Local\Temp\RtmpYHjzuR/downloaded_packages/RMySQL_0.8-0.tar.gz' had status 1
2: In install.packages("RMySQL", type = "source") :
installation of package 'RMySQL' had non-zero exit status
Sys.getenv('MYSQL_INC')
[1] ""
Sys.getenv('MYSQL_LIB')
[1] ""
Sys.getenv('MYSQL_DIR')
[1] ""
Sys.getenv('MYSQL_HOME')
[1] "C:/PROGRA~1/MySQL/MYSQLS~1.5/"
Sys.getenv('MYSQL_INC')
[1] ""
Sys.getenv('MYSQL_LIB')
[1] ""
Sys.getenv('MYSQL_DIR')
[1] ""
Sys.getenv('MYSQL_HOME')
[1] "C:/PROGRA~1/MySQL/MYSQLS~1.5/"*
所有这些都使用R版本2.13.2.
我最近在WinXP 32位上安装了RMySQL,并且也遇到了一些问题.我已经在以下链接
几天前,我还跟进了软件包维护者.我还没有收到回复.希望我们可以更好地记录该过程.看来您的问题可以通过发出r语句来解决:
Sys.setenv(MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQLS~1.5″)
在安装RMySQL之前.
I'm quite new to R, but I've some experience in programming. I'm trying to install RMySQL on Windows 7 with MySQL Workbench 5.2 and I keep on getting the same errors. I've already checked different procedures, but keep on getting stuck:
http://vhaguiar.wordpress.com/2011/06/06/r-how-to-install-rmysql-in-windows-7-with-mysql-5-5/
http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL
MySQL is up and running, I have moved libmysql.lib and libmysql.dll, but I keep on getting the following errors. I guess I cannot see the problem for what it really is. Do you have any suggestion?
install.packages("RMySQL", type="source")
--- Please select a CRAN mirror for use in this session ---
provo con l'URL 'http://cran.rakanu.com/src/contrib/RMySQL_0.8-0.tar.gz'
Content type 'application/x-gzip' length 160735 bytes (156 Kb)
URL aperto
downloaded 156 Kb
** installing *source* package 'RMySQL' ...
ERROR: configuration failed for package 'RMySQL'
* removing 'C:/Program Files/R/R-2.13.2/library/RMySQL'
The downloaded packages are in
‘C:\Users\Matteo\AppData\Local\Temp\RtmpYHjzuR\downloaded_packages’
Warning messages:
1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/i386/R CMD INSTALL -l "C:/Program Files/R/R-2.13.2/library" C:\Users\Matteo\AppData\Local\Temp\RtmpYHjzuR/downloaded_packages/RMySQL_0.8-0.tar.gz' had status 1
2: In install.packages("RMySQL", type = "source") :
installation of package 'RMySQL' had non-zero exit status
Sys.getenv('MYSQL_INC')
[1] ""
Sys.getenv('MYSQL_LIB')
[1] ""
Sys.getenv('MYSQL_DIR')
[1] ""
Sys.getenv('MYSQL_HOME')
[1] "C:/PROGRA~1/MySQL/MYSQLS~1.5/"
Sys.getenv('MYSQL_INC')
[1] ""
Sys.getenv('MYSQL_LIB')
[1] ""
Sys.getenv('MYSQL_DIR')
[1] ""
Sys.getenv('MYSQL_HOME')
[1] "C:/PROGRA~1/MySQL/MYSQLS~1.5/"*
This is all using R version 2.13.2.
I recently installed RMySQL on WinXP 32-bit and had some issues as well. I have documented the issues I had and solutions I found at the following link
I also followed up with the package maintainer a few days ago. I haven't received a response yet. Hopefully we can better document the process. It seems your problem may be solved by issuing the r statement:
Sys.setenv("MYSQL_HOME"="C:/PROGRA~1/MySQL/MYSQLS~1.5″)
before installing RMySQL.
这篇关于Mysql 5.5的RMySQL安装问题的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!