RMySQL install on windows

Hi, I've followed these steps:


I set the MYSQL_HOME environmental variable like this:
"c:\PROGRA~1\MySQL\MYSQLS~1.5", then I opened a command prompt, got to the
folder that contains the "RMySQL_0.9-3.tar.gz" file, and run the command:
"c:\Program Files\R\R-2.15.1\bin\x64\R" CMD INSTALL RMySQL_0.9-3.tar.gz

However, I keep getting those "cygwin warnings".

'those "cygwin warnings"' tell you how to turn them off.

When I try to load the package: "library(RMySQL)" R tells that "there is no
package called 'RMySQL')

Then the installation step failed and you have to report the output your 
got if you want to get any help.

Uwe Ligges

My R version is 2.15.1 (x64),  on Windows 7 (64-bit).
I have installed MySQL Server 5.5 (64-bit), and MySQL Connector C 6.0.2
(64-bit).

How could you solve those warnings you've mentioned?





--
View this message in context: http://r.789695.n4.nabble.com/RMySQL-install-on-windows-tp4645629p4648769.html
Sent from the R help mailing list archive at Nabble.com.

______________________________________________
R-help at 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.

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' 







--
View this message in context: http://r.789695.n4.nabble.com/RMySQL-install-on-windows-tp4645629p4649510.html
Sent from the R help mailing list archive at Nabble.com.

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

Uwe, I set the variable with single backslashes, but the output remains the
same. The last part reads:

"gcc -m64 -shared -s -static-libgcc -o RMySQL.dll tmp.def RS-DBI.o
RS-MySQL.o C:\Program Files\MySQL\MySQL Server 5.5/bin/libmysql.dll
-Ld:/RCompile/CRANpkg/extralibs64/local/lib/x64
-Ld:/Rcompile/CRANpkg/extralibs64/local/lib
-LC:/PROGRA~1/R/R-215~1.1/BIN/X64 -lR
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' " 





--
View this message in context: http://r.789695.n4.nabble.com/RMySQL-install-on-windows-tp4645629p4649590.html
Sent from the R help mailing list archive at Nabble.com.

Uwe, I set the variable with single backslashes, but the output remains the
same. The last part reads:

"gcc -m64 -shared -s -static-libgcc -o RMySQL.dll tmp.def RS-DBI.o
RS-MySQL.o C:\Program Files\MySQL\MySQL Server 5.5/bin/libmysql.dll
-Ld:/RCompile/CRANpkg/extralibs64/local/lib/x64
-Ld:/Rcompile/CRANpkg/extralibs64/local/lib
-LC:/PROGRA~1/R/R-215~1.1/BIN/X64 -lR
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 error message says it can't find a particular file.  You may have
an incomplete installation or perhaps in your distribution the file is
not in the expected place.  First look for it:

cd %MYSQL_HOME%
dir/s/b libmySQL.dll

If its missing then there is a problem with your installation of MySQL.

If its in a different location than expected copy it to the expected
location. Do that as Administrator:

    copy ...wherever...\libmySQL.dll %MYSQL_HOME%\bin

If it happens again with some other file then copy it too.

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

An embedded and charset-unspecified text was scrubbed...
Name: not available
URL: <https://stat.ethz.ch/pipermail/r-help/attachments/20121116/a9f7dc2a/attachment.pl>