Dear all -- I was facing some problems with the last versions of R and RMySQL. Someone saw my post on another forum and answered me. And now... it works! Here is the message: " I was having the same problem (well, except for the French part) and I solved it like this: Download the windows MySQL 5.0 release here: http://dev.mysql.com/get/Downloads/MySQL-5.0/mysql-noinstall-5.0.45-win32.zip/from/pick#mirrors ( Click “ No thanks, just take me to the downloads! ” and pick a mirror . ) Then unzip the file and go into the bin folder and grab libmysql.dll . Put this in your R-2.6.0\bin directory. Then restart R and the problem should be solved."
Prof Brian Ripley a écrit : > I don't understand why you are trying to install a 2.5.x binary on R > 2.6.0. Perhaps if you tried not to make things so hard for yourself > and just used the Packages menu to install RMySQL this might work: it > does for me and quite a few others. > > Otherwise, you do need libMySQL.dll on the path or copied to the same > directory as RMySQL.dll to be sure that is not the issue. I suspect it > is rather an R version mismatch. > > On Mon, 12 Nov 2007, Joachim Claudet wrote: > >> Dear list members -- >> >> I have problems in loading the pre-compiled library RMySQL_0.5-7 taken >> here (http://stat.bell-labs.com/RS-DBI/download/index.html) or >> RMySQL_0.6-0 taken here >> (http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.5/) on R 2.6.0 >> under Windows XP. I am using the MySQL features of EasyPHP1-8 (but the >> problem is not (for the moment) in connecting with a database but just >> in loading the package) > >> I have seen all the previous posts explaining to copy the libMySQL.dll & >> RMySQL.dll of the RMySQL library in the Windows/System32 folder or to >> change the path variable in the Environment Variables of the system but >> nothing helps. > > I do wish people would not write things like that. Give URLs of what > you have read, since > > - very often it is not 'all'. > - sometimes it is misread. > - some of the self-appointed experts are founts of misinformation (as > apparently here), so we need to know the credentials. > >> I still have the following message (I am sorry but, unfortunately, it is >> in French; with my translation): > > You can always start R in English (see the rw-FAQ) to quote English > messages. I would have expected there to be a message box as well (at > least under XP) saying what the missing procedure was (and that would > be in French, no doubt). > > >> Error in dyn.load(file, ...) : >> impossible de charger la bibliothèque partagée (="impossible to charge >> the shared library") >> 'C:/PROGRA~1/R/R-26~1.0/library/RMySQL/libs/RMySQL.dll': >> LoadLibrary failure: La procédure spécifiée est introuvable (="the >> specified procedure cannot be found"). >> Erreur : le chargement du package / espace de noms a échoué pour >> 'RMySQL' (="loading package/space of names failed for") >> >> >> I have just changed my computer and was previously on R 2.4, where I did >> not have any problems in installing and loading pre-compiled versions >> RMySQL. >> >> Any help will be welcome. >> >> - Joachim Claudet >> >> > -- <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< Joachim Claudet - PhD http://joachim.claudet.free.fr/ Skype: joachim.claudet Laboratory of Zoology and Marine Biology Department of Biological and Environmental Science and Technologies University of Salento - via Monteroni 73100 Lecce, Italy Phone: +39 0832 298853 Fax: +39 0832 298626 Email: [EMAIL PROTECTED] <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< <º)))>< ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.
