[R] RMySQL install on windows

[Gabor Grothendieck]

On Wed, Nov 14, 2012 at 12:11 PM, sbarandiaran <sbarandia at gmail.com> wrote:
> Uwe, now I've tried these steps, following RMySQL installation instructions
> (http://cran.r-project.org/web/packages/RMySQL/INSTALL):
>
> 1. Download the RMySQL_0.9.tar.gz file to the folder C:\Program
> Files\R\R-2.15.1\bin\x64
> 2. Open a Windows command line, and change directory to that folder
> 3. Enter the following commands:
>       set MYSQL_HOME=C:\\Program Files\\MySQL\\MySQL Server 5.5
>       R CMD INSTALL RMySQL_0.9.tar.gz
>
> The output ends with:
> "gcc.exe: error:  C:\Program Files\MySQL\MySQL Server 5.5/bin/libmySQL.dll:
> No such file or directory
> ERROR: compilation failed for package 'RMySQL'
> * removing 'C:/Users/Acer/Documents/R/win-library/2.15/RMySQL' "
>
> The problem seems to be that it points to an incorrect folder to find the
> file 'libmySQL.dll' . This file is located at  'C:\Program Files\MySQL\MySQL
> Server 5.5/lib'
>

MYSQL_HOME is incorrect.  Windows uses single backslashes -- not double.

(R uses double backslash within "..." to produce a single backsloash
but that step was done in Windows console and not in R.)

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