Win7上安装RMySQL，终于成功了！！！！

记录在win7上安装RMySQL的经验，搞了一下下午接一个晚上，因为我R用了绿色版，上次重装系统后没有安装R，于是一直出错。

下面记录正确的过程：

1、安装R，用绿色的貌似不行，我就是在这步上走了太多弯路

2、安装RTools，注意版本

3、安装MySQL

4、在R的安装目录D:\green soft\R\R-3.0.2\etc下新建Renviron.site文件，并在里面添加MYSQL_HOME=D:/green soft/mysql/mysql-5.5.27-win32（这里是你的mysql根目录，注意是反斜杠）内容。然后采用Sys.getenv('MYSQL_HOME')看看返回的值是不是你指定的。这步务必成功，不然后面必定失败！

5、将mysql/lib下面的libmysql.lib,libmysql.dll 文件拷贝到 mysql/lib/opt 文件夹下，不存在opt文件夹就新建一个。

6、将mysql/lib下的libmysql.dll 文件拷贝到\R-3.0.2\bin 或者windows/system32中，我的拷贝到了R-2.12.1\bin中。

7、在R中运行install.packages('RMySQL',type='source')，需要等待比较长的时间，最终将会看到 DONE (RMySQL)的提示，表示成功。

看返回值：

> install.packages('RMySQL', type ='source')
--- 在此連線階段时请选用CRAN的鏡子 ---
试开URL’http://mirrors.xmu.edu.cn/CRAN/src/contrib/RMySQL_0.9-3.tar.gz'
Content type 'application/x-gzip' length 165363 bytes (161 Kb)
打开了URL
downloaded 161 Kb

* installing *source* package 'RMySQL' ...
** 成功将'RMySQL'程序包解包并MD5和检查
checking for $MYSQL_HOME... D:/green soft/mysql/mysql-5.5.27-win32
cygwin warning:
MS-DOS style path detected: D:/green
Preferred POSIX equivalent is: /cygdrive/d/green
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
test: soft/mysql/mysql-5.5.27-win32: unknown operand
** libs
警告: this package has a non-empty 'configure.win' file,
so building only the main architecture

cygwin warning:
MS-DOS style path detected: D:/GREENS~1/R/R-30~1.2/etc/i386/Makeconf
Preferred POSIX equivalent is: /cygdrive/d/GREENS~1/R/R-30~1.2/etc/i386/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 -m32 -I"D:/GREENS~1/R/R-30~1.2/include" -DNDEBUG -I"D:/green soft/mysql/mysql-5.5.27-win32"/include -I"d:/RCompile/CRANpkg/extralibs64/local/include" -O3 -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 -m32 -I"D:/GREENS~1/R/R-30~1.2/include" -DNDEBUG -I"D:/green soft/mysql/mysql-5.5.27-win32"/include -I"d:/RCompile/CRANpkg/extralibs64/local/include" -O3 -Wall -std=gnu99 -mtune=core2 -c RS-MySQL.c -o RS-MySQL.o
RS-MySQL.c: In function 'RS_MySQL_fetch':
RS-MySQL.c:657:13: warning: variable 'fld_nullOk' set but not used [-Wunused-but-set-variable]
RS-MySQL.c: In function 'RS_DBI_invokeBeginGroup':
RS-MySQL.c:1137:30: warning: variable 'val' set but not used [-Wunused-but-set-variable]
RS-MySQL.c: In function 'RS_DBI_invokeNewRecord':
RS-MySQL.c:1158:20: warning: variable 'val' set but not used [-Wunused-but-set-variable]
RS-MySQL.c: In function 'RS_MySQL_dbApply':
RS-MySQL.c:1219:38: warning: variable 'fld_nullOk' set but not used [-Wunused-but-set-variable]
gcc -m32 -shared -s -static-libgcc -o RMySQL.dll tmp.def RS-DBI.o RS-MySQL.o D:/green soft/mysql/mysql-5.5.27-win32/lib/opt/libmysql.lib -Ld:/RCompile/CRANpkg/extralibs64/local/lib/i386 -Ld:/RCompile/CRANpkg/extralibs64/local/lib -LD:/GREENS~1/R/R-30~1.2/bin/i386 -lR
installing to D:/green soft/R/R-3.0.2/library/RMySQL/libs/i386
** R
** inst
** preparing package for lazy loading
Creating a generic function for 'format' from package 'base' in package 'RMySQL'
Creating a generic function for 'print' from package 'base' in package 'RMySQL'
** help
*** installing help indices
** building package indices
** installing vignettes
** testing if installed package can be loaded
MYSQL_HOME defined as D:/green soft/mysql/mysql-5.5.27-win32
* DONE (RMySQL)

下载的程序包在
‘C:\Users\wayswang\AppData\Local\Temp\RtmpWWk63U\downloaded_packages’里

开源的东西，用起来真的很辛苦，我不太喜欢这种自己捣鼓的东西，也终于明白像微软这种公司存在的理由了，因为我爱微软这种一套解决的方案。