I am having trouble loading RMySQL after installing it. I have looked
at archived r-help files and it seems many people have had issues, but I
didn't find my specific issue. I also went to the webpage at Vanderbilt
(http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL) and followed the
instructions as best I understood them:
- I created a file called Renviron.site under "etc" in the R
folder. In it, I tried to put a pointer to where MySQL is.
I tried:
- MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQL~Server~5.5/
- MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQLS~5.5/bin
(which are guesses at how this should be written from the
example on the webpage.)
- MYSQL_HOME=C:/Program Files/MySQL/MySQL Server 5.5
(the actual location; n.b. adding "\bin" yields the
location of the mysql.exe file)
- I then re-start R and attempt to load the package.
- I get the following error messages:
Loading required package: DBI
Error : MYSQL_HOME was set but does not point to a directory
Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'
Does anyone know how to write this so that it does point to the
directory properly?Or, what else might be the problem?
Thanks,
Jeff
PS, I am running windows XP media edition and R 2.10.1, if that matters.
(I apologize if this ends up being posted twice, I tried to
post it earlier, and it didn't seem to 'take'.)
I am having trouble loading RMySQL after installing it. I have looked
at archived r-help files and it seems many people have had issues, but I
didn't find my specific issue. I also went to the webpage at Vanderbilt
(http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL) and followed the
instructions as best I understood them:
- I created a file called Renviron.site under "etc" in the R
folder. In it, I tried to put a pointer to where MySQL is.
I tried:
- MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQL~Server~5.5/
- MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQLS~5.5/bin
(which are guesses at how this should be written from the
example on the webpage.)
- MYSQL_HOME=C:/Program Files/MySQL/MySQL Server 5.5
(the actual location; n.b. adding "\bin" yields the
location of the mysql.exe file)
- I then re-start R and attempt to load the package.
- I get the following error messages:
Loading required package: DBI
Error : MYSQL_HOME was set but does not point to a directory
Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'
Does anyone know how to write this so that it does point to the
directory properly?Or, what else might be the problem?
Thanks,
Jeff
PS, I am running windows XP media edition and R 2.10.1, if that matters.
On Thu, Oct 27, 2011 at 1:46 PM, Jeff Laux <jefflaux at gmail.com> wrote:> I am having trouble loading RMySQL after installing it. ?I have looked at > archived r-help files and it seems many people have had issues, but I didn't > find my specific issue. ?I also went to the webpage at Vanderbilt > (http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL) and followed the > instructions as best I understood them: > > ? ?- I created a file called Renviron.site under "etc" in the R folder. ?In > it, I tried to put a pointer to where MySQL is. > ? ? ? ?I tried: > ? ? ? ? ? ?- MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQL~Server~5.5/ > ? ? ? ? ? ?- MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQLS~5.5/bin > ? ? ? ? ? ? ?(which are guesses at how this should be written from the > example on the webpage.) > ? ? ? ? ? ?- MYSQL_HOME=C:/Program Files/MySQL/MySQL Server 5.5 > ? ? ? ? ? ? ?(the actual location; n.b. adding "\bin" yields the location of > the mysql.exe file) > ? ?- I then re-start R and attempt to load the package. > ? ?- I get the following error messages: > > Loading required package: DBI > Error : MYSQL_HOME was set but does not point to a directory > Error : .onLoad failed in 'loadNamespace' for 'RMySQL' > Error: package/namespace load failed for 'RMySQL' > > Does anyone know how to write this so that it does point to the directory > properly?Or, what else might be the problem? > > Thanks, > Jeff > > PS, I am running windows XP media edition and R 2.10.1, if that matters. >Check out: http://r.789695.n4.nabble.com/RMySQL-problem-on-Windows-7-32-bit-tt3520472.html#a3522409 -- Statistics & Software Consulting GKX Group, GKX Associates Inc. tel: 1-877-GKX-GROUP email: ggrothendieck at gmail.com