RMySQL install on windows

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