[R-sig-DB] Connect R to MySQL DB installed via XAMPP

[Prof Brian Ripley]

On 25/06/2012 15:12, julien cuisinier wrote:
>
> Hi List,
>
>
>
> Just to update, I could find a zip online (I unfortunately lost the address & cannot find it anymore) RMySQL_0.8-0_for_MySQL_5.5.16.zip
>
> which when installed locally under R allowed me to connect... not ideal but at leats it works for the time being.
>
> Any feedback on my email / question is more than welcome

You start from mendacious assumptions, and installing Windows source 
packages is way off topic here.

But you should not need administrative rights to install Rtools ....

>
>
> Thanks & regards,
> Julien
>
>
>
> From: j_cuisinier using hotmail.com
> To: r-sig-db using r-project.org
> Subject: FW: Connect R to MySQL DB installed via XAMPP
> Date: Mon, 25 Jun 2012 13:46:27 +0200
>
>
>
>
>
>
>
>
>
>
> Hi List,
>
>
> On windows XP & R2.15. Session info below.
>
> I installed XAMPP on my machine - I can't install MYSQL on the C:\Program file dir because no admin rights, so I installed XAMPP onto a personal directory...which I guess makes things slightly harder, but I am hopeful I am not thhe first one struggling on this!
>
> Any feedback  redirection / hints hugely appreciated
>
>
>
> (1) I tried to install RMySQL which I used successsfully on Linux in the past but it seems to be a trouble on Windows, no binary available on CRAN (anymore?) & when trying the "type = 'source' " option I get the following:
>
>> install.packages("RMySQL",type="source")
> trying URL 'http://cran.ma.imperial.ac.uk/src/contrib/RMySQL_0.9-3.tar.gz'
> Content type 'application/x-gzip' length 165363 bytes (161 Kb)
> opened URL
> downloaded 161 Kb
>
> '\\UKLonHome.HDS.Int\Home$\julien.cuisinier'
> CMD.EXE was started with the above path as the current directory.
> UNC paths are not supported.  Defaulting to Windows directory.
> * installing *source* package 'RMySQL' ...
> ** package 'RMySQL' successfully unpacked and MD5 sums checked
> ERROR: configuration failed for package 'RMySQL'
> * removing 'P:/PersoServer/Programs/R/R-2.15.0/library/RMySQL'
>
> The downloaded source packages are in
>          ‘C:\Documents and Settings\julien.cuisinier\Local Settings\Temp\RtmpszNeip\downloaded_packages’
> Warning messages:
> 1: running command 'P:/PersoServer/Programs/R/R-2.15.0/bin/i386/R CMD INSTALL -l "P:/PersoServer/Programs/R/R-2.15.0/library"   C:\DOCUME~1\JULIEN~1.CUI\LOCALS~1\Temp\RtmpszNeip/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1
> 2: In install.packages("RMySQL", type = "source") :
>    installation of package ‘RMySQL’ had non-zero exit status
>
>
> (2) I can't use tips like this one:
> http://blog.tersmitten.nl/archives/1345
>
> simply because I can't install RTools.exe as I do not have admin rights
> NB: I already changed the env. variable MYSQL_HOME but without success:
>> Sys.getenv("MYSQL_HOME")
> [1] "P:/PersoServer/Programs/XAMPP/mysql"
>
>
>
> (2) So I thought to try & connect directly using DBI package, but I am having an error msge I do not understand (My apologies if this is basic, not expert at all on DB management)
>> library(DBI)
>> drv <- dbDriver("MYSQL")
> Error in do.call(as.character(drvName), list(...)) :
>    could not find function "MYSQL"
>
> googling, I found the following but I do not get the answer from Prof Brian Ripley:
> http://r.789695.n4.nabble.com/connecting-to-DB2-database-td827626.html
>
> I am guessing the "driver package" he refers to is RMySQL which I could not install in the first place... I tried to fiddle with the R files you have access once you extract the tar.gz source package under RMySQL\R, but no luck
>> source("zzz.R")
>> source("S4R.R")
>> source("dbObjectId.R")
>> source("MySQLSupport.R")
>> source("MySQL.R")
>> drv <- dbDriver("MYSQL")
> Error in do.call(as.character(drvName), list(...)) :
>    could not find function "MYSQL"
>
> weird thing is that in the "MySQL.R" file from the source package downloaded there is a "MYSQL" function declared - I am guessing the error is somewhere else but R is not very helpful here (my own limitation of course...)
>
>
> Any idea of where to go from here would be hugely appreciated!! Sorry for the long email.
>
>
> Thanks & regards,
> Julien
>
>
>
>
>
>> sessionInfo()
> R version 2.15.0 (2012-03-30)
> Platform: i386-pc-mingw32/i386 (32-bit)
>
> locale:
> [1] LC_COLLATE=English_United Kingdom.1252  LC_CTYPE=English_United Kingdom.1252
> [3] LC_MONETARY=English_United Kingdom.1252 LC_NUMERIC=C
> [5] LC_TIME=English_United Kingdom.1252
>
> attached base packages:
> [1] stats     graphics  grDevices utils     datasets  methods   base
>
> other attached packages:
> [1] DBI_0.2-5
>
>   		 	   		   		 	   		   		 	   		
> 	[[alternative HTML version deleted]]
>
>
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using r-project.org
> https://stat.ethz.ch/mailman/listinfo/r-sig-db
>


-- 
Brian D. Ripley,                  ripley using stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595