将 RMySQL 包添加到 R 失败(在 Windows 上)?

2021-11-20 00:00:00 r package mysql rmysql

我不知道为什么我的 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!

推荐答案

基本流程描述这里，但是有几个提示，所以我将描述整个解决方案(如果需要，请更改 R 版本和路径):

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):

  1. 从此处
    2. 安装最新的 RTools
  2. 安装MySQL或mysql的头文件和库文件
  3. 创建或编辑文件 C:\Program Files\R\R-2.12.1\etc\Renviron.site 并添加类似 MYSQL_HOME=C:/mysql 的行(你的mysql文件的路径)
  4. 将 libmysql.lib 从 mysql/lib 复制到 mysql/lib/opt 以满足依赖项.
  5. 将 libmysql.dll 复制到 C:\Program Files\R\R-2.12.1\bin 或 windows/system32 目录.
  6. 运行 install.packages('RMySQL',type='source') 并等待编译结束.
  1. Install latest RTools from here
  2. install MySQL or header and library files of mysql
  3. create or edit file C:\Program Files\R\R-2.12.1\etc\Renviron.site and add line like MYSQL_HOME=C:/mysql (path to your mysql files)
  4. copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies.
  5. copy libmysql.dll to C:\Program Files\R\R-2.12.1\bin or to windows/system32 directory.
  6. 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).

相关文章