[R] install RMySQL under Mac OS X 10.4.7

[Brian D Ripley]

If this is R as installed from CRAN, it is by default looking for a binary
and not a source package.

Please study the `R Installation and Administration' manual.

On Wed, 5 Jul 2006, Luo Weijun wrote:

> Hello All,
>
> I tried to install RMySQL package, but the error
> messages says there is no such package, even though I
> did see RMySQL is there in the contributed package
> list in all mirror sites of CRAN I tried. Not sure
> what is the problem.
>
> > mysql.home <- '/usr/local/mysql'
> >
> Sys.putenv('PKG_CPPFLAGS'=paste('-I',file.path(mysql.home,'include'),sep=''))
>
> >
> Sys.putenv('PKG_LIBS'=paste('-L',file.path(mysql.home,'lib'),'
> -lmysqlclient',sep=''))
> > install.packages('RMySQL', repos =
> "http://www.biometrics.mtu.edu/CRAN/",dependencies =T)
> dependency ''RMySQL'' is not available
> > install.packages('RMySQL', repos =
> "http://www.biometrics.mtu.edu/CRAN/")
> Warning in download.packages(pkgs, destdir = tmpd,
> available = available,  :
>          no package 'RMySQL' at the repositories
>
> I tried download the package manually under unix, and
> install it from within R, and no luck too.
>
> cd ~/download/R
> curl -O
> http://www.biometrics.mtu.edu/CRAN/src/contrib/RMySQL_0.5-7.tar.gz

And where did you run R from?  I think you needed to give a full path here
....

> > install.packages( 'RMySQL_0.5-7.tar.gz', repos =
> NULL)
> Error in gzfile(file, "r") : unable to open connection
> In addition: Warning message:
> cannot open compressed file
> 'RMySQL_0.5-7.tar.gz/DESCRIPTION'
> >
>
> > sessionInfo()
> Version 2.3.0 (2006-04-24)
> powerpc-apple-darwin8.6.0
>
> attached base packages:
> [1] "methods"   "stats"     "graphics"  "grDevices"
> "utils"     "datasets"
> [7] "base"
>
>
> could anybody tell me what happens here, and how to
> fix the problem? Thank you so much!
> Weijun
>
> ______________________________________________
> R-help at stat.math.ethz.ch mailing list
> https://stat.ethz.ch/mailman/listinfo/r-help
> PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
>

-- 
Brian D. Ripley,                  ripley at 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