WIN7下面如何安装RMySQL

最新推荐文章于 2024-02-26 15:20:48 发布

原创最新推荐文章于 2024-02-26 15:20:48 发布 · 2.4k 阅读

0 ·

CC 4.0 BY-SA版权

R 语言学习专栏收录该内容

18 篇文章

订阅专栏

本文记录了在R 3.1.1版本下安装RMySQL包过程中遇到的问题及尝试解决的过程。由于二进制包不可用，尝试从源代码安装失败，并出现配置错误，最终决定放弃使用RMySQL，转而考虑ODBC链接方案。

一、系统简介

> R.version
               _                           
platform       x86_64-w64-mingw32          
arch           x86_64                      
os             mingw32                     
system         x86_64, mingw32             
status                                     
major          3                           
minor          1.1                         
year           2014                        
month          07                          
day            10                          
svn rev        66115                       
language       R                           
version.string R version 3.1.1 (2014-07-10)
nickname       Sock it to Me

二、错误提示信息

> install.packages("RMySQL")

   package ‘RMySQL’ is available as a source package but not as a binary

Warning in install.packages :
  package ‘RMySQL’ is not available (for R version 3.1.1)
> install.packages("RMySQL", type="source")
trying URL 'http://cran.rstudio.com/src/contrib/RMySQL_0.9-3.tar.gz'
Content type 'application/x-gzip' length 165363 bytes (161 Kb)
opened URL
downloaded 161 Kb

* installing *source* package 'RMySQL' ...
** 成功将'RMySQL'程序包解包并MD5和检查
警告: 运行命令'sh ./configure.win'的状态是127
ERROR: configuration failed for package 'RMySQL'
* removing 'd:/Program Files/R/R-3.1.1/library/RMySQL'
Warning in install.packages :
  running command '"d:/PROGRA~2/R/R-31~1.1/bin/x64/R" CMD INSTALL -l "d:\Program Files\R\R-3.1.1\library" C:\Users\ADMINI~1\AppData\Local\Temp\RtmpETbHru/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1
Warning in install.packages :
  installation of package ‘RMySQL’ had non-zero exit status

The downloaded source packages are in
	‘C:\Users\Administrator\AppData\Local\Temp\RtmpETbHru\downloaded_packages’

三、找到源代码包，通过源代码包安装

需要cygwim，所以我放弃，改用odbc链接数据库