在 Windows 8.1 中安装 RMySQL 时的另一个错误 [英] Another error when installing RMySQL in Windows 8.1

问题描述

我有一台 Windows 8.1 机器并使用 R 3.0.3 和 RTools 30.我正在尝试安装 RMySQL，我按照 http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/ 和另一个 StackOverflow 帖子但我一遍又一遍地得到这个错误:

<块引用>

 安装 *source* 包 'RMySQL' ...包 'RMySQL' 成功解包并检查 MD5 总和0 [main] sh 3240 find_fast_cwd:警告:无法计算 FAST_CWD 指针.请将此问题报告给公共邮件列表 [e-mail]检查 $MYSQL_HOME...C:/Program Files/MySQL/MySQL Server 5.6/"测试:文件/MySQL/MySQL:未知操作数cygwin警告:检测到 MS-DOS 样式路径:C:/PROGRA~1/R/R-30~1.3/bin/x64/Rscript首选的 POSIX 等效项是:/cygdrive/c/PROGRA~1/R/R-30~1.3/bin/x64/RscriptCYGWIN 环境变量选项nodosfilewarning"关闭此警告.有关 POSIX 路径的更多详细信息，请参阅用户指南:http://cygwin.com/cygwin-ug-net/using.html#using-pathnames库警告:这个包有一个非空的configure.win"文件，所以只建造主要架构0 [main] make 4640 find_fast_cwd:警告:无法计算 FAST_CWD 指针.请将此问题报告给公共邮件列表 [e-mail]警告:检测到 MS-DOS 样式路径:C:/PROGRA~1/R/R-30~1.3/etc/x64/Makeconf首选的 POSIX 等效项是:/cygdrive/c/PROGRA~1/R/R-30~1.3/etc/x64/MakeconfCYGWIN 环境变量选项nodosfilewarning"关闭此警告.有关 POSIX 路径的更多详细信息，请参阅用户指南:http://cygwin.com/cygwin-ug-net/using.html#using-pathnamesgcc -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.oRS-DBI.c:在函数RS_na_set"中:RS-DBI.c:1219:11: 警告:变量 'c' 已设置但未使用 [-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在 RS-MySQL.c:22:0 包含的文件中:RS-MySQL.h:32:19: 致命错误: mysql.h: 没有那个文件或目录编译终止.制作:*** [RS-MySQL.o] 错误 1警告:运行命令 '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"' 状态为 2错误:程序包RMySQL"编译失败删除C:/Users/Yohanan/Documents/R/win-library/3.0/RMySQL"install.packages 中的警告:运行命令 '"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\Yohan\AppData\Local\Temp\RtmpysBrc8/downloaded_pa​​ckages/RMySQL_0.9-3.tar.gz' 的状态为 1install.packages 中的警告:安装包RMySQL"的退出状态非零

你能帮我吗?谢谢...

解决方案

可能是您的 MySQL 安装出了问题.

错误是指缺少注册表项，如此处所述: MySQL 手册 - MySQL 安装，搜索 SOFTWARE\MySQL AB 会显示说明注册表外观的部分.使用 regedit.exe，您可以自行修复此问题.

关于如何使用regedit.exe的信息:Techsupportalert - 在一个简单的课程中注册

它对我有同样的问题

I have a Windows 8.1 machine and use R 3.0.3 and RTools 30. I'm trying to install RMySQL and I followed the instructions from http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/ and another StackOverflow posts but I get this error over and over:

  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 [e-mail]
 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 [e-mail]
 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

Can you please help me? Thank you...

解决方案

Probably something went wrong with your MySQL installation.

The error refers to registry keys missing as documented here: MySQL Manual - MySQL Installation, searching for SOFTWARE\MySQL AB reveals the section stating how the registry should look like. With regedit.exe you can fix this yourself.

Information on how to use regedit.exe: Techsupportalert - Regedit in One Easy Lesson

It worked for me with the same problem

这篇关于在 Windows 8.1 中安装 RMySQL 时的另一个错误的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！