How to install RMysql on Windows 7 with proxy settings
I am fighting with the installation of RMysql on R2.13.0 on Windows 7 64bit.  The version of my mysql 5.5. Here are the steps, which led me to an error:

 1. Install RTools
 2. Set up proxy by calling: `setInternet2(TRUE)` after [FAQ@CRAN][1]
 3. Set MYSQL_HOME: `Sys.setenv("MYSQL_HOME"="C:\\Program Files\\MySQL\\MySQL Server 5.5\\")` after [this post on SO][2]
 4. Call in R Console: `install.packages("RMySQL", type="source")`

After 4, I got the following error:

    Installing package(s) into ‘C:/Users/Foo/Documents/R/win-library/2.13’
    (as ‘lib’ is unspecified)
    Warning: unable to access index for repository http://artfiles.org/cran/src/contrib
    Warning message:
    In getDependencies(pkgs, dependencies, available, lib) :
      package ‘RMySQL’ is not available (for R version 2.13.0)

Alternative to 4 is just to install the package: `install.packages("RMySQL")`. In this case I got:

    Installing package(s) into ‘C:/Users/foo/Documents/R/win-library/2.13’
    (as ‘lib’ is unspecified)
    Warning: unable to access index for repository http://artfiles.org/cran/bin/windows/contrib/2.13
    Warning message:
    In getDependencies(pkgs, dependencies, available, lib) :
      package ‘RMySQL’ is not available (for R version 2.13.0)

I am sure that I do not have problems with connection, because I can call R update. 
Could anybody help me to find out how I can access mysql db from R?

ps. Here is output from sessionInfo()

    R version 2.13.0 (2011-04-13)
    Platform: i386-pc-mingw32/i386 (32-bit)
    
    locale:
    [1] LC_COLLATE=German_Germany.1252  LC_CTYPE=German_Germany.1252   
    [3] LC_MONETARY=German_Germany.1252 LC_NUMERIC=C                   
    [5] LC_TIME=German_Germany.1252    
    
    attached base packages:
    [1] stats     graphics  grDevices utils     datasets  methods   base     
    
    loaded via a namespace (and not attached):
    [1] tools_2.13.0


  [1]: http://cran.r-project.org/bin/windows/base/rw-FAQ.html#The-Internet-download-functions-fail_002e
  [2]: http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails/4792884#4792884
How to install RMysql on Windows 7 with proxy settings
===

I am fighting with the installation of RMysql on R2.13.0 on Windows 7 64bit.  The version of my mysql 5.5. Here are the steps, which led me to an error:

 1. Install RTools
 2. Set up proxy by calling: `setInternet2(TRUE)` after [FAQ@CRAN][1]
 3. Set MYSQL_HOME: `Sys.setenv("MYSQL_HOME"="C:\\Program Files\\MySQL\\MySQL Server 5.5\\")` after [this post on SO][2]
 4. Call in R Console: `install.packages("RMySQL", type="source")`

After 4, I got the following error:

    Installing package(s) into ‘C:/Users/Foo/Documents/R/win-library/2.13’
    (as ‘lib’ is unspecified)
    Warning: unable to access index for repository http://artfiles.org/cran/src/contrib
    Warning message:
    In getDependencies(pkgs, dependencies, available, lib) :
      package ‘RMySQL’ is not available (for R version 2.13.0)

Alternative to 4 is just to install the package: `install.packages("RMySQL")`. In this case I got:

    Installing package(s) into ‘C:/Users/foo/Documents/R/win-library/2.13’
    (as ‘lib’ is unspecified)
    Warning: unable to access index for repository http://artfiles.org/cran/bin/windows/contrib/2.13
    Warning message:
    In getDependencies(pkgs, dependencies, available, lib) :
      package ‘RMySQL’ is not available (for R version 2.13.0)

I am sure that I do not have problems with connection, because I can call R update. 
Could anybody help me to find out how I can access mysql db from R?

ps. Here is output from sessionInfo()

    R version 2.13.0 (2011-04-13)
    Platform: i386-pc-mingw32/i386 (32-bit)
    
    locale:
    [1] LC_COLLATE=German_Germany.1252  LC_CTYPE=German_Germany.1252   
    [3] LC_MONETARY=German_Germany.1252 LC_NUMERIC=C                   
    [5] LC_TIME=German_Germany.1252    
    
    attached base packages:
    [1] stats     graphics  grDevices utils     datasets  methods   base     
    
    loaded via a namespace (and not attached):
    [1] tools_2.13.0


  [1]: http://cran.r-project.org/bin/windows/base/rw-FAQ.html#The-Internet-download-functions-fail_002e
  [2]: http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails/4792884#4792884