R help - Feb 2010 - Update RMySQL and ... it's no more running

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 sorry) is just below. It seems there is a
problem with the registry key but I'm not good enough to solve this (without
the MySQL Gui Tools, it also doesn't work).
Below the error message, you will find the result of the command
readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)

If someone can help me ...
Thanks in advance,
Have a nice week-end,
Ptit Bleu.


> library(RMySQL)
Le chargement a n?cessit? le package : DBI
Error in fun(...) : 
  A MySQL Registry key was found but the folder C:\MySQL\MySQL Tools for
5.0\/. doesn't contain a bin or lib/opt folder. That's where we need to
find
libmySQL.dll. 
De plus : Warning messages:
1: le package 'RMySQL' a ?t? compil? avec la version R 2.9.2 
2: le package 'DBI' a ?t? compil? avec la version R 2.9.2 
Error : .onLoad a ?chou? dans 'loadNamespace' pour 'RMySQL'
Erreur : le chargement du package / espace de noms a ?chou? pour
'RMySQL'
> readRegistry("SOFTWARE\\MySQL AB", hive="HLM",
maxdepth=2)
$`MySQL Administrator 1.2`
$`MySQL Administrator 1.2`$Location
[1] "C:\\MySQL\\MySQL Tools for 5.0\\"

$`MySQL Administrator 1.2`$Version
[1] "5.0.17"


$`MySQL Connector/ODBC 3.51`
$`MySQL Connector/ODBC 3.51`$Version
[1] "3.51.27"


$`MySQL Migration Toolkit 1.1`
$`MySQL Migration Toolkit 1.1`$Location
[1] "C:\\MySQL\\MySQL Tools for 5.0\\"

$`MySQL Migration Toolkit 1.1`$Version
[1] "5.0.17"


$`MySQL Query Browser 1.2`
$`MySQL Query Browser 1.2`$Location
[1] "C:\\MySQL\\MySQL Tools for 5.0\\"

$`MySQL Query Browser 1.2`$Version
[1] "5.0.17"


$`MySQL Server 5.1`
$`MySQL Server 5.1`$DataLocation
[1] "C:\\MySQL\\MySQL Server 5.1\\"

$`MySQL Server 5.1`$FoundExistingDataDir
[1] "0"

$`MySQL Server 5.1`$Location
[1] "C:\\MySQL\\MySQL Server 5.1\\"

$`MySQL Server 5.1`$Version
[1] "5.1.44"


$`MySQL Tools for 5.0`
$`MySQL Tools for 5.0`$Location
[1] "C:\\MySQL\\MySQL Tools for 5.0\\"

$`MySQL Tools for 5.0`$Version
[1] "5.0.17"



-- 
View this message in context:
http://n4.nabble.com/Update-RMySQL-and-it-s-no-more-running-tp1561401p1561401.html
Sent from the R help mailing list archive at Nabble.com.

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 each time.
Is there a way to definitively set the variable value ?

Thank in advance,
Have a nice week-end,
Ptit Bleu.

> Sys.setenv("MYSQL_HOME"="C:/MySQL/MySQL Server 5.1")
> Sys.getenv('MYSQL_HOME')
                 MYSQL_HOME 
"C:/MySQL/MySQL Server 5.1" 
> library(DBI)
Warning message:
le package 'DBI' a ?t? compil? avec la version R 2.9.2 
> library(RMySQL)
Warning messages:
1: le package 'RMySQL' a ?t? compil? avec la version R 2.9.2 
2: In inDL(x, as.logical(local), as.logical(now), ...) : 

   RMySQL was compiled with MySQL 5.0.67 but loading MySQL 5.1.44 instead!
   This may cause problems with your database connections.

   Please install MySQL 5.0.67.

   If you have already done so, you may need to set your environment
   variable MYSQL_HOME to the proper install directory.

-- 
View this message in context:
http://n4.nabble.com/Update-RMySQL-and-it-s-no-more-running-tp1561401p1561677.html
Sent from the R help mailing list archive at Nabble.com.