Skip to content

Problem when loading package RMySQL

3 messages · ..., Brian Ripley

Original
...
# 
Hello,
I have a problem when loading RMySQL 0.7-5 on Windows 7 64 bit and
with a 64-bit version of MySQL 5.1.
My R version is 2.11.1 32-bit. I installed it from here:
http://ftp.yalwa.org/cran/bin/windows/base/R-2.11.1-win32.exe

I then installed RMySQL using a local zip file from here:
http://cran.r-project.org/web/packages/RMySQL/index.html
Windows binary: RMySQL_0.7-5.zip

Here is the error:
Error : .onLoad in loadNamespace() fehlgechlagen, Details:
  Aufruf: RMySQL
  Fehler: inDL(x, as.logical(local), as.logical(now), ...)
Fehler: Laden von Paket/Namensraum f?r 'RMySQL' fehlgeschlagen

My Path seems to be set correctly:
MYSQL_HOME
"C:\\Program Files\\MySQL\\MySQL Server 5.1"

Any help would be appreciated!
Cheers
Brian Ripley
# 
It looks like you set MYSQL_HOME to point to a 64-bit MySQL, since 
C:\Program Files\ is for 64-bit software.  For 32-bit R you need a 
32-bit MySQL client (although you can use this with a 64-bit server).
On Sat, 21 Aug 2010, ... wrote:

            

      
      
      
    

        

      
      
    

        

  
    

      
      
    

  


  


      

    

    

      
      

        


  

        

      ...
    

    

      
      #
    

  


  

      
Is there a RMySQL package for 64-bit R for Windows?
I had the 64-bit R installed before, but got similar errors. Thats why I
switched to 32-bit R.

        
On Sat, Aug 21, 2010 at 7:04 PM, Prof Brian Ripley <ripley at stats.ox.ac.uk>wrote: