Hello,
After an upgrade, RGui was crashing each time I was trying to connect to
MySQL database.
The error message was again : 'RMySQL was compiled with MySQL 5.0.67 but
loading MySQL 5.1.44'
I found an https://stat.ethz.ch/pipermail/r-sig-db/2009q1/000572.html old
discussion giving this
http:
Yep this worked. I encountered this problem only after installing the ODBC
connector plugin. Not sure if there's any correlation. I installed the
MySQL 5.1.33 binary from
http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL
and that will fixed 'RMySQL was compiled with MySQL 5.0.67 but loading My
If you only need it while in R you can use the RENVIRON file or the
.Rprofile or Rprofile.site file. Use help in R to find more on this.
environment variables can also be set through the control panel.
Google to get instructions.
Another possibility is the free command line Windows utility seten
Just to say that I found the place to set the environment variables
(Computer/Properties/Advanced/Environment variables). The warning is still
there but the connection seems ok.
Concerning the warning, do you think I have to install an older version of
mysql ?
By the way, I also copied RMySQL.dl
Hello again,
After 'googling', I set the environment variable MYSQL_HOME value to the
path to MYSQL with the command below.
I get a warning (is it a problem or not ???) but I managed to connect to my
databases.
But when I close and open again R, the connection is lost. I have to run the
command
Hello,
I updated the RMySQL (and DBI) package but, since, it doesn't run anymore.
I followed the advices given here
http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL
but with no success.
I also copied the libMySQL.dll in the bin directory of R. Also no good
result.
The error message (in french
6 matches
Mail list logo
