[R] Failed to install RMySQL,help!

[Gabor Grothendieck]

On Fri, Nov 23, 2012 at 3:29 AM, li1127217ye <li1127217ye at 163.com> wrote:
> I had installed R and MySQL ,then I input :
>> install.packages('RMySQL',type='source')
> show the message below, Why? Why shows   "ERROR: configuration failed for
> package 'RMySQL'"?
>
> ÊÔ¿ª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ºÍ¼ì²é
> ERROR: configuration failed for package 'RMySQL'
> * removing 'F:/Program Files/R/R-2.15.2/library/RMySQL'
>
> ÏÂÔصijÌÐò°üÔÚ
>
> ¡®C:\Users\Administrator\AppData\Local\Temp\RtmpmeIp6y\downloaded_packages¡¯Àï
> ¾¯¸æÐÅÏ¢£º
> 1: ÔËÐÐÃüÁî'F:/PROGRA~1/R/R-215~1.2/bin/i386/R CMD INSTALL -l "F:/Program
> Files/R/R-2.15.2/library"
> C:\Users\ADMINI~1\AppData\Local\Temp\RtmpmeIp6y/downloaded_packages/RMySQL_0.9-3.tar.gz'µÄ״̬ÊÇ1
> 2: In install.packages("RMySQL", type = "source") :
>   °²×°³ÌÐò°ü¡®RMySQL¡¯Ê±Í˳ö î‘BµÄÖµ²»ÊÇ0
>

I can't tell from that output what the problem is but recently a user
reported that the dll files in their MySQL distribution were not at
the place expected by the installer.  Check out this in case its the
same problem:

http://r.789695.n4.nabble.com/RMySQL-install-on-windows-tp4645629p4649628.html

--
Statistics & Software Consulting
GKX Group, GKX Associates Inc.
tel: 1-877-GKX-GROUP
email: ggrothendieck at gmail.com