[R-sig-DB] Error connecting R to mysql

[Christophe Dutang]

Hi,

I also got this error when I update mysql from 5.0 to 5.1... I get rid  
of this error by uninstalling MySQL (both main program and gui) and  
manually removing register key that contain reference to older MySQL  
5.0. For the last step, I just use regedit in the windows "shell" and  
Ctrl+F to search for mysql. Before reinstalling MySQL 5.1, I also  
remove the directory C:\Program Files\MySQL.

Hope this method will work for you.

Christophe

PS : check also MySQL is not present in the PATH variable before  
reinstalling MySQL



Le 16 mai 09 � 20:47, Ian Coe a �crit :

> Hi,
>
>   I am experiencing the error copied below when I call  
> library(RMySQL).
> I have done complete installs of mysql 5.1, mysql GUI tools, and MySQL
> connector/C on WinXP.     I found the following exchange from this  
> list
> regarding a very similar sounding error (also copied below) and went
> back over my install settings to see if I missed anything.  I do not  
> see
> anything left to install.   Does anyone have any suggestions for  
> what to
> try next?
>
> Thanks so much for your help.
>
> -Ian
>
> My error:
> A MySQL Registry key was found but the folder C:\Program
> Files\MySQL\MySQL Tools for 5.0\/. doesn't contain a bin or lib/opt
> folder. That's where we need to find libmySQL.dll.
> Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
> Error: package/namespace load failed for 'RMySQL'
>
>
> Related message from a previous post:
>   Yakub wrote:
>> I have the following error:
>>> library(RMySQL)
>> Error in fun(...) :
>>  A MySQL Registry key was found but the folder C:\Program
> Files\MySQL\MySQL
>> Tools for 5.0\/. doesn't contain a bin or lib/opt folder. That's  
>> where
> we
>> need to find libmySQL.dll.
>> Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
>> Error: package/namespace load failed for 'RMySQL'
>>
>> This happens after I install MySQL Tools. Seems that R is pointing to
> the
>> wrong registry. Can anyone help?
>
> You need to install the client programs and libraries when you install
> the MySQL distribution. Just re-run the MySQL installer again and be
> sure to read the steps carefully.
>
> Best,
>
> Jeff
>
> _______________________________________________
> R-sig-DB mailing list -- R Special Interest Group
> R-sig-DB using stat.math.ethz.ch
> https://stat.ethz.ch/mailman/listinfo/r-sig-db

Christophe Dutang
Ph. D. student at ISFA, Lyon, France
website: http://dutangc.free.fr




	[[alternative HTML version deleted]]