[R] R and mysql on debian

[Johannes Ranke]

Hello all,

thanks for all the help. I would like to summarize:

If you want to use the same R scripts for accessing a mysql
database from Windows and Debian/GNU Linux, you can either

1. install the RMySQL source package from CRAN under debian, and compile it
under Windows as well (this sounds a little hairy to me)

2. install unixodbc, compile myODBC 2.50 from www.mysql.org,
and install RODBC from CRAN on debian, and install RODBC and myODBC under
Windows. This worked for me.

Option 2. also involved installing libmysqlclient10-dev and the source package
for mysql under debian.

Best regards

Johannes Ranke

* Johannes Ranke <jranke at uni-bremen.de> [020606 17:34]:
> Hello,
> 
> I have been using RODBC on Windows with version 1.41 of R successfully,
> connecting to a mysql database using MyODBC. Now I would like to do so
> with R under Debian/GNU Linux. 
> 
> I just tried RMySQL (install failed, since mysql libraries were not found),
> DBI (no MySQL driver available) and I can't find the RODBC package
> any more on CRAN.
> 
> Any suggestions?
> 
> Johannes Ranke
> 
> P.S.: Thanks for all the great work to all!
> -.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
> r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
> Send "info", "help", or "[un]subscribe"
> (in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
> _._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._
> 
-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-.-
r-help mailing list -- Read http://www.ci.tuwien.ac.at/~hornik/R/R-FAQ.html
Send "info", "help", or "[un]subscribe"
(in the "body", not the subject !)  To: r-help-request at stat.math.ethz.ch
_._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._._