[R-sig-DB] problem loading RMySQL

[Jim Burke]

I am sure everyone encounters this and its rather
old hat. Forgive me for belaboring the obvious.

Sometimes various install packages I attempt
to install die in that last part. They download
OK, they unzip OK but sometimes error in the
updating HTML part.

(By the way my error cause was having a cluttered
PC environment. Specifically having FireFox open.
If I reboot and only open R and retry the install,
it usually works.)

So in Windows I got to
C:\Program Files\R\R 2.90\R-2.9.0\library

I will see an unusually named file there
. for example file5f906952
. the file date will reflect my recent install date
. looking in the subdirectory of file5f906952, I see
  name of the package I was trying to install.
. In my example above that subdirectory was file5f906952\PBSmapping
. So I pasted PBSmapping and all its subdirectories in the 
library\PBSmapping
. And was able to use PBSmapping

Hope this helps,
Jim Burke

Jeffrey Horner wrote:
> Milstead.Bryan using epamail.epa.gov wrote on 04/30/2009 11:56 AM:
>>
>> Hi Jeff:  thanks for getting back to me so quickly. 
>> Here is the output::
>>
>>  > sessionInfo()
>> R version 2.8.1 (2008-12-22)
>> i386-pc-mingw32
>>
>> locale:
>> LC_COLLATE=English_United States.1252;LC_CTYPE=English_United 
>> States.1252;LC_MONETARY=English_United 
>> States.1252;LC_NUMERIC=C;LC_TIME=English_United States.1252
>>
>> attached base packages:
>> [1] stats     graphics  grDevices datasets  tcltk     utils     
>> methods   base   
>> other attached packages:
>> [1] ineq_0.2-8      foreign_0.8-34  DBI_0.2-4       svSocket_0.9-43 
>> svMisc_0.9-46   TinnR_1.0.3    [7] R2HTML_1.59-1   Hmisc_3.5-2   
>> loaded via a namespace (and not attached):
>> [1] cluster_1.11.13 grid_2.8.1      lattice_0.17-22 tools_2.8.1     > 
>> .libPaths()
>> [1] 
>> "//AA.AD.EPA.GOV/ORD/NAR/USERS/EC2/wmilstea/NETMYD~1/PORTAB~2/R/R-28~1.1/library" 
>>
>>  > Sys.getenv('MYSQL_HOME')
>> MYSQL_HOME
>>         ""
>>  > utils::readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
>> $`MySQL Connector/ODBC 5.1`
>> $`MySQL Connector/ODBC 5.1`$Version
>> [1] "5.1.5"
>>
>
> See http://biostat.mc.vanderbilt.edu/RMySQL
>
> You haven't installed the MySQL client libraries.
>
> 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
>
>