There is also the binary: [1]http://stat.bell-labs.com/RS- DBI/download/RMySQL/RMySQL_0.5-7.zip Ting-Yuan Liu wrote: Hi Amy, I just found that there is no "RMySQL_0.5-7.zip" in the CRAN, so please ignore my previous message. Try this: source([2]"http://bioconductor.org/biocLite.R") biocLite("RMySQL") This works in my XP machine, so it should also work at yours. HTH, Ting-Yuan ______________________________________ Ting-Yuan Liu Program in Computational Biology Division of Public Health Sciences Fred Hutchinson Cancer Research Center Seattle, WA, USA ______________________________________ On Wed, 22 Feb 2006, Amy Mikhail wrote: Dear list, R: 2.2.1, Bioconductor: 1.7, OS: windows XP I recently downloaded the package BioMArt, which has RMySQL listed as one of its dependencies. Although I can see this package when I go to the CRAN website (Bristol mirror), I'm not able to find or download it from R and I get this warning: install.packages(c("RMySQL")) Warning in download.packages(pkgs, destdir = tmpd, available = available, : no package 'RMySQL' at the repositories If I try using the pull-down menu (install packages...) the package is not even on the list (actually comparing the website and the list, there are quite a few packages that don't show up). Also, if I download RMySQL_0.5-7.tar.gz from the CRAN website and try using "install packages from local zip files", it doesn't work either: utils:::menuInstallLocal() Error in gzfile(file, "r") : unable to open connection In addition: Warning messages: 1: error 1 in extracting from zip file 2: cannot open compressed file 'RMySQL_0.5-7.tar.gz/DESCRIPTION' So how (and from where) can I get hold of RMySQL? Regards, Amy ------------------------------------------- Amy Mikhail Research student University of Aberdeen Zoology Building Tillydrone Avenue Aberdeen AB24 2TZ Scotland Email: [3]a.mikhail at abdn.ac.uk Phone: 00-44-1224-272880 (lab) _______________________________________________ Bioconductor mailing list [4]Bioconductor at stat.math.ethz.ch [5]https://stat.ethz.ch/mailman/listinfo/bioconductor _______________________________________________ Bioconductor mailing list [6]Bioconductor at stat.math.ethz.ch [7]https://stat.ethz.ch/mailman/listinfo/bioconductor -- David Tuck, M.D. Department of Pathology Pathology Informatics Yale University School of Medicine BML 38C 310 Cedar St. New Haven, CT 06510 Ph: 203 785-4562 Fax:203 785-3644 References 1. http://stat.bell-labs.com/RS- DBI/download/RMySQL/RMySQL_0.5-7.zip 2. http://bioconductor.org/biocLite.R 3. mailto:a.mikhail at abdn.ac.uk 4. mailto:Bioconductor at stat.math.ethz.ch 5. https://stat.ethz.ch/mailman/listinfo/bioconductor 6. mailto:Bioconductor at stat.math.ethz.ch 7. https://stat.ethz.ch/mailman/listinfo/bioconductor

Hi all, Thanks for the info - it worked with BiocLite. Cheers, Amy > Hi Amy, > > Amy Mikhail wrote: >> Dear list, >> >> R: 2.2.1, Bioconductor: 1.7, OS: windows XP >> >> I recently downloaded the package BioMArt, which has RMySQL listed as >> one >> of its dependencies. Although I can see this package when I go to the >> CRAN website (Bristol mirror), I'm not able to find or download it from >> R >> and I get this warning: >> >> >>>install.packages(c("RMySQL")) >> >> Warning in download.packages(pkgs, destdir = tmpd, available = >> available, : >> no package 'RMySQL' at the repositories >> >> If I try using the pull-down menu (install packages...) the package is >> not >> even on the list (actually comparing the website and the list, there >> are >> quite a few packages that don't show up). >> >> Also, if I download RMySQL_0.5-7.tar.gz from the CRAN website and try >> using "install packages from local zip files", it doesn't work either: >> >> >>>utils:::menuInstallLocal() >> >> Error in gzfile(file, "r") : unable to open connection >> In addition: Warning messages: >> 1: error 1 in extracting from zip file >> 2: cannot open compressed file 'RMySQL_0.5-7.tar.gz/DESCRIPTION' >> >> So how (and from where) can I get hold of RMySQL? > > I believe this same question was asked and answered earlier today on > this listserv. Anyway, > > source("http://www.bioconductor.org/biocLite.R") > biocLite("RMySQL") > > should do the trick. > > Note that with most source packages (xx.tar.gz), you will need quite a > few tools installed to build on Windows (see the R-FAQ for windows). > This is even more work for this particular package, so the best bet is > to get a pre-compiled binary. > > Best, > > Jim > > >> >> Regards, >> Amy >> >> >> >> >> ------------------------------------------- >> Amy Mikhail >> Research student >> University of Aberdeen >> Zoology Building >> Tillydrone Avenue >> Aberdeen AB24 2TZ >> Scotland >> Email: a.mikhail at abdn.ac.uk >> Phone: 00-44-1224-272880 (lab) >> >> _______________________________________________ >> Bioconductor mailing list >> Bioconductor at stat.math.ethz.ch >> https://stat.ethz.ch/mailman/listinfo/bioconductor > > > -- > James W. MacDonald > University of Michigan > Affymetrix and cDNA Microarray Core > 1500 E Medical Center Drive > Ann Arbor MI 48109 > 734-647-5623 > > > > ********************************************************** > Electronic Mail is not secure, may not be read every day, and should not > be used for urgent or sensitive issues. > ------------------------------------------- Amy Mikhail Research student University of Aberdeen Zoology Building Tillydrone Avenue Aberdeen AB24 2TZ Scotland Email: a.mikhail at abdn.ac.uk Phone: 00-44-1224-272880 (lab)