无法在Windows 8上安装RMySQL

I followed the installation directions at R-Bloggers website. However once I do the install.packages('RMySQL',type='source'), I get the following error. It appears that there is some conflict with regards to the path (Windows likes backward slashes whereas here the installer is trying to look up by unix style backward slashes). Any ideas what is going wrong?

我按照R-Bloggers网站上的安装说明进行操作。但是,一旦我执行install.packages('RMySQL',type ='source'),我就会收到以下错误。看起来路径存在一些冲突(Windows喜欢反斜杠,而安装程序试图通过unix样式反斜杠查找)。出了什么问题?

--- Error Message --- install.packages('RMySQL',type='source')

---错误信息--- install.packages('RMySQL',type ='source')

Installing package(s) into ‘C:/Software/R-2.15.2/library’ (as ‘lib’ is unspecified)

将软件包安装到'C:/Software/R-2.15.2/library'中(未指定'lib')

trying URL 'http://cran.rstudio.com/src/contrib/RMySQL_0.9-3.tar.gz'

尝试网址'http://cran.rstudio.com/src/contrib/RMySQL_0.9-3.tar.gz'

Content type 'application/x-gzip' length 165363 bytes (161 Kb)

内容类型'application / x-gzip'长度165363字节(161 Kb)

opened URL

downloaded 161 Kb

下载了161 Kb

installing source package 'RMySQL' ...

安装源包'RMySQL'......

** package 'RMySQL' successfully unpacked and MD5 sums checked

**包'RMySQL'成功解压缩并检查MD5总和

checking for $MYSQL_HOME... C:\Software\xampp\mysql

检查$ MYSQL_HOME ... C:\ Software \ xampp \ mysql

cygwin warning:

MS-DOS style path detected: C:\Software\xampp\mysql

检测到MS-DOS样式路径:C:\ Software \ xampp \ mysql

Preferred POSIX equivalent is: /cygdrive/c/Software/xampp/mysql

首选的POSIX等价物是:/ cygdrive / c / Software / xampp / mysql

CYGWIN environment variable option "nodosfilewarning" turns off this warning.

CYGWIN环境变量选项“nodosfilewarning”将关闭此警告。

Consult the user's guide for more details about POSIX paths:

有关POSIX路径的更多详细信息,请参阅用户指南:

http://cygwin.com/cygwin-ug-net/using.html#using-pathnames

** libs Warning: this package has a non-empty 'configure.win' file,

** libs警告:这个包有一个非空的'configure.win'文件,

so building only the main architecture

所以只建立主体系结构

cygwin warning:

MS-DOS style path detected: C:/Software/R-215~1.2/etc/x64/Makeconf

检测到MS-DOS样式路径:C:/Software/R-215~1.2/etc/x64/Makeconf

Preferred POSIX equivalent is: /cygdrive/c/Software/R-215~1.2/etc/x64/Makeconf

首选的POSIX等价物是:/cygdrive/c/Software/R-215~1.2/etc/x64/Makeconf

CYGWIN environment variable option "nodosfilewarning" turns off this warning.

CYGWIN环境变量选项“nodosfilewarning”将关闭此警告。

Consult the user's guide for more details about POSIX paths:

有关POSIX路径的更多详细信息,请参阅用户指南:

http://cygwin.com/cygwin-ug-net/using.html#using-pathnames

gcc -m64 -I"C:/Software/R-215~1.2/include" -DNDEBUG -I"C:\Software\xampp\mysql"/include -I"d:/RCompile/CRANpkg/extralibs64/local/include" -O2 -Wall -std=gnu99 -mtune=core2 -c

gcc -m64 -I“C:/Software/R-215~1.2/include”-DNDEBUG -I“C:\ Software \ xampp \ mysql”/ include -I“d:/ RCompile / CRANpkg / extralibs64 / local / include “-O2 -Wall -std = gnu99 -mtune = core2 -c

RS-DBI.c -o RS-DBI.o

RS-DBI.c: In function 'RS_na_set':

RS-DBI.c:在函数'RS_na_set'中:

RS-DBI.c:1219:11: warning: variable 'c' set but not used [-Wunused-but-set-variable]

RS-DBI.c:1219:11:警告:变量'c'设置但未使用[-Wunused-but-set-variable]

gcc -m64 -I"C:/Software/R-215~1.2/include" -DNDEBUG -I"C:\Software\xampp\mysql"/include -I"d:/RCompile/CRANpkg/extralibs64/local/include" -O2 -Wall -std=gnu99 -mtune=core2 -c

RS-MySQL.c -o RS-MySQL.o

RS-MySQL.c: In function 'RS_MySQL_fetch':

RS-MySQL.c:在函数'RS_MySQL_fetch'中:

RS-MySQL.c:657:13: warning: variable 'fld_nullOk' set but not used [-Wunused-but-set-variable]

RS-MySQL.c:657:13:警告:变量'fld_nullOk'设置但未使用[-Wunused-but-set-variable]

RS-MySQL.c: In function 'RS_DBI_invokeBeginGroup':

RS-MySQL.c:在函数'RS_DBI_invokeBeginGroup'中:

RS-MySQL.c:1137:30: warning: variable 'val' set but not used [-Wunused-but-set-variable]

RS-MySQL.c:1137:30:警告:变量'val'设置但未使用[-Wunused-but-set-variable]

RS-MySQL.c: In function 'RS_DBI_invokeNewRecord':

RS-MySQL.c:在函数'RS_DBI_invokeNewRecord'中:

RS-MySQL.c:1158:20: warning: variable 'val' set but not used [-Wunused-but-set-variable]

RS-MySQL.c:1158:20:警告:变量'val'设置但未使用[-Wunused-but-set-variable]

RS-MySQL.c: In function 'RS_MySQL_dbApply':

RS-MySQL.c:在函数'RS_MySQL_dbApply'中:

RS-MySQL.c:1219:38: warning: variable 'fld_nullOk' set but not used [-Wunused-but-set-variable]

RS-MySQL.c:1219:38:警告:变量'fld_nullOk'设置但未使用[-Wunused-but-set-variable]

gcc -m64 -shared -s -static-libgcc -o RMySQL.dll tmp.def RS-DBI.o RS-MySQL.o

C:\Software\xampp\mysql/bin/libmySQL.dll -Ld:/RCompile/CRANpkg/extralibs64/local/lib/x64 -Ld:/RCompile/CRANpkg/extralibs64/local/lib -LC:/Software/R-215~1.2/bin/x64 -lR

C:\ Software \ xampp \ mysql / bin / libmySQL.dll -Ld:/ RCompile / CRANpkg / extralibs64 / local / lib / x64 -Ld:/ RCompile / CRANpkg / extralibs64 / local / lib -LC:/ Software / R- 215~1.2 / bin / x64 -lR

gcc.exe: error: C:\Software\xampp\mysql/bin/libmySQL.dll: No such file or directory

gcc.exe:错误:C:\ Software \ xampp \ mysql / bin / libmySQL.dll:没有这样的文件或目录

ERROR: compilation failed for package 'RMySQL'

错误:包'RMySQL'的编译失败

removing 'C:/Software/R-2.15.2/library/RMySQL'

Warning in install.packages : running command 'C:/Software/R-215~1.2/bin/x64/R CMD INSTALL -l "C:/Software/R-2.15.2/library"

install.packages中的警告:运行命令'C:/Software/R-215~1.2/bin/x64/R CMD INSTALL -l“C:/Software/R-2.15.2/library”

C:\Users\lenovo\AppData\Local\Temp\RtmpiIQAUp/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1

C:\ Users \ lenovo \ AppData \ Local \ Temp \ RtmpiIQAUp / downloaded_packages / RMySQL_0.9-3.tar.gz'状态为1

Warning in install.packages :

install.packages中的警告:

installation of package ‘RMySQL’ had non-zero exit status

包'RMySQL'的安装具有非零退出状态

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

下载的源包位于'C:\ Users \ lenovo \ AppData \ Local \ Temp \ RtmpiIQAUp \ downloaded_packages'中

1 个解决方案

#1

Just copy all the files and folders from inside lib to the bin folder.

只需将lib内的所有文件和文件夹复制到bin文件夹即可。

For some strange reason the installer looks for the lib files in the bin directory.

出于某种奇怪的原因,安装程序会在bin目录中查找lib文件。

#1