我有一台Windows 8.1计算机,并使用R 3.0.3和RTools30。我正在尝试安装RMySQL,我按照http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/和另一个StackOverflow帖子中的说明进行操作,但是我一遍又一遍地遇到此错误:
installing *source* package 'RMySQL' ...
package 'RMySQL' successfully unpacked and MD5 sums checked
0 [main] sh 3240 find_fast_cwd: WARNING: Couldn't compute FAST_CWD pointer. Please report this problem to
the public mailing list [email protected]
checking for $MYSQL_HOME... â€C:/Program Files/MySQL/MySQL Server 5.6/â€
test: Files/MySQL/MySQL: unknown operand
cygwin warning:
MS-DOS style path detected: C:/PROGRA~1/R/R-30~1.3/bin/x64/Rscript
Preferred POSIX equivalent is: /cygdrive/c/PROGRA~1/R/R-30~1.3/bin/x64/Rscript
CYGWIN environment variable option "nodosfilewarning" turns off this warning.
Consult the user's guide for more details about POSIX paths:
http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
libs
Warning: this package has a non-empty 'configure.win' file,
so building only the main architecture
0 [main] make 4640 find_fast_cwd: WARNING: Couldn't compute FAST_CWD pointer. Please report this problem to
the public mailing list [email protected]
cygwin warning:
MS-DOS style path detected: C:/PROGRA~1/R/R-30~1.3/etc/x64/Makeconf
Preferred POSIX equivalent is: /cygdrive/c/PROGRA~1/R/R-30~1.3/etc/x64/Makeconf
CYGWIN environment variable option "nodosfilewarning" turns off this warning.
Consult the user's guide for more details about POSIX paths:
http://cygwin.com/cygwin-ug-net/using.html#using-pathnames
gcc -m64 -I"C:/PROGRA~1/R/R-30~1.3/include" -DNDEBUG -I"â€C:/Program Files/MySQL/MySQL Server 5.6/â€"/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:1219:11: warning: variable 'c' set but not used [-Wunused-but-set-variable]
gcc -m64 -I"C:/PROGRA~1/R/R-30~1.3/include" -DNDEBUG -I"â€C:/Program Files/MySQL/MySQL Server 5.6/â€"/include -I"d:/RCompile/CRANpkg/extralibs64/local/include" -O2 -Wall -std=gnu99 -mtune=core2 -c RS-MySQL.c -o RS-MySQL.o
In file included from RS-MySQL.c:22:0:
RS-MySQL.h:32:19: fatal error: mysql.h: No such file or directory
compilation terminated.
make: *** [RS-MySQL.o] Error 1
Warning: running command 'make -f "Makevars.win" -f "C:/PROGRA~1/R/R-30~1.3/etc/x64/Makeconf" -f "C:/PROGRA~1/R/R-30~1.3/share/make/winshlib.mk" SHLIB="RMySQL.dll" WIN=64 TCLBIN=64 OBJECTS="RS-DBI.o RS-MySQL.o"' had status 2
ERROR: compilation failed for package 'RMySQL'
removing 'C:/Users/Yohanan/Documents/R/win-library/3.0/RMySQL'
Warning in install.packages :
running command '"C:/PROGRA~1/R/R-30~1.3/bin/x64/R" CMD INSTALL -l "C:\Users\Yohanan\Documents\R\win-library\3.0" C:\Users\Yohanan\AppData\Local\Temp\RtmpysBrc8/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1
Warning in install.packages :
installation of package ‘RMySQL’ had non-zero exit status
你能帮我么?谢谢...
最佳答案
您的MySQL安装可能出了点问题。
该错误是指注册表项丢失,如此处记录:MySQL Manual - MySQL Installation,搜索SOFTWARE \ MySQL AB将显示说明注册表外观的部分。使用regedit.exe,您可以自己修复此问题。
有关如何使用regedit.exe的信息:Techsupportalert - Regedit in One Easy Lesson
它对我有同样的问题