On Wed, Nov 14, 2012 at 12:11 PM, sbarandiaran <sbaran...@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 ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.