Hi ALL has anyone recently installed the package RMySQL? I found the zip file and installed it and it was successful, but then the library gives error: > utils:::menuInstallLocal() package 'RMySQL' successfully unpacked and MD5 sums checked > library(RMySQL) Error : .onLoad failed in loadNamespace() for 'RMySQL', details: call: utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth = 2) error: Registry key 'SOFTWARE\MySQL AB' not found Error: package/namespace load failed for 'RMySQL' > I don't what to do about it. can anyone please help me. Thanks a lot Leila

Hi Leila, l.mohammadikhankahdani wrote: > Hi ALL > has anyone recently installed the package RMySQL? > I found the zip file and installed it and it was successful, but then > the library gives error: > > > utils:::menuInstallLocal() > package 'RMySQL' successfully unpacked and MD5 sums checked > > library(RMySQL) > Error : .onLoad failed in loadNamespace() for 'RMySQL', details: > call: utils::readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth > = 2) > error: Registry key 'SOFTWARE\MySQL AB' not found > Error: package/namespace load failed for 'RMySQL' > > > > I don't what to do about it. can anyone please help me. First off, RMySQL isn't a Bioconductor package, so this question is better asked on R-help. Secondly, the background you give is woefully inadequate. Remember in the future to let people know what OS you are using, and the results of sessionInfo() so we know what versions of packages you are using as well. I can tell you are on Windows based on the readRegistry call above, but you shouldn't rely upon the abilities of people to divine these things. So to your question. The RMySQL package uses MySQL to do things, so you need to have MySQL installed as well. If you are going to use the Windows binary, then the version of MySQL that you install has to match the version that RMySQL was built against. Reasonable instructions can be found here: http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL Which you could have found by, say, googling RMySQL. When working with open source packages, it is well worth your time to become capable of figuring things out yourself. The helpers on the various lists are very good, but you will only get so far relying on others to show you the way. Personally, I prefer to build from sources so I am not always having to find the correct version of MySQL for a given version of RMySQL. This may involve more work than using the binary, but as with all things there are pluses and minuses. If interested, the instructions I have posted for myself can be found here: http://www-personal.umich.edu/~jmacdon/rmysql_winbuild.htm Best, Jim > Thanks a lot > Leila > > _______________________________________________ > Bioconductor mailing list > Bioconductor at stat.math.ethz.ch > https://stat.ethz.ch/mailman/listinfo/bioconductor > Search the archives: > http://news.gmane.org/gmane.science.biology.informatics.conductor -- James W. MacDonald, M.S. Biostatistician Douglas Lab University of Michigan Department of Human Genetics 5912 Buhl 1241 E. Catherine St. Ann Arbor MI 48109-5618 734-615-7826 ********************************************************** Electronic Mail is not secure, may not be read every day, and should not be used for urgent or sensitive issues