similar to: Problem with library(RMySQL), registry pointer problem?

Hi Everyone, I am relatively new to R, but I want to try to learn how to use it and potentially replace the other commercial packages I have learned to use over the years. That said, I need to get at data in databases, more specifically, MySQL. I installed the RMySQL package without error, but when I try to load it, I get the following error: > library(RMySQL) Loading required package: DBI

Hi, I am brand new to the world of R, so please bare with me while I goof my way through a question. I am attempting to trial using R with MySQL. The MySQL server is on a Linux box and I am using the Windows (32bit XP) version of R. I have installed RMySQL successfully, however when I load it I get the error: Error : .onLoad failed in loadNamespace() for 'RMySQL', details: call:

Trying to install RMySQL on 64-bit Windows 7. Using R-2.14.2 with Rtools214 and MySQL Server 5.5. Read through several step-by-steps of RMySQL source installation. Troubleshooting: - Copied libmysql.dll to R-2.14.2/bin AND R-2.14.2/bin/i386. - Copied libmysql.dll and libmysql.lib to MySQL Server 5.5\lib\opt. - Entered MYSQL_HOME=C:\Program Files\MySQL\MySQL Server 5.5 into Renviron.site,

Hello, I am trying to compile/Install RMySQL_0.6-0 in R-2.4.1/2.5.0 under Windows XP MCE, I am using MySQL 5.0.41. I have followed the instructions in the file INSTALL.win, but I get some errors... C:\Program Files\R\R-2.4.1>Rcmd build --binary RMySQL --docs=normal * checking for file 'RMySQL/DESCRIPTION' ... OK * preparing 'RMySQL': * checking DESCRIPTION meta-information

Hello everyone, I have a question regarding building the Rmysql packages from source in Windows. I am currently using: Windows XP, R-2.2.0, Mysql 3.23 I have installed all of the tools from Installation and Administration and after following all the instructions to the letter, I compiled the binary and installed R 2.2.0 from source with no issues. This is the first time I have compiled the

Hi, I have struggled to re-implement the RMySQL package after upgrading from SuSe 6.3 to 7.2 and from R 1.2.1 to R 1.3.1, to no avail It compiles happily but when loading the package I get the following error > library(RMySQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/home/jniesch/R_HOME/lib/R/library/RMySQL/libs/RMySQL.so":

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

I am facing issues while installing RMySQL package on windows(32 bit) installation of R-Project. I am getting the following warning messages. Warning messages: 1: running command 'C:/PROGRA~1/R/R-213~1.2/bin/i386/R CMD INSTALL -l "C:/Program Files/R/R-2.13.2/library" D:\DOCUME~1\nagga002\LOCALS~1\Temp\RtmpLZndlE/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1 2: In

Hi, On a Win7 64 bit, I have installed: *R-15.0 and I am running it in 64bits *Rtools215.exe*MySQL 5.5.23 64bits My PATH start with D:\BenSave\Rtools\bin;D:\BenSave\Rtools\MinGW64\bin;D:\BenSave\R\R-2.15.0\bin;D:\BenSave\Rtools\MinGW\bin;D:\BenSave\Rtools\gcc-4.6.3\bin; Note that I place MinGW64\bin has I want the package in 64 bits, so just in case it helps... To install RMySQL 64 bits, I

I am attempting to analyze Affymetrix exonchip data using the exon map package. I have installed this package but have had problems installing the associated programs, specifically RMySQL since no windows binary exists. I have followed the directions for compiling the package as found on - http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL - but still have an error when executing the

Dear list members -- I have problems in loading the pre-compiled library RMySQL_0.5-7 taken here (http://stat.bell-labs.com/RS-DBI/download/index.html) or RMySQL_0.6-0 taken here (http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.5/) on R 2.6.0 under Windows XP. I am using the MySQL features of EasyPHP1-8 (but the problem is not (for the moment) in connecting with a database but just

I have been trying to install RMySQL on Windows 7 following the procedure at: http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL I think I have properly installed RTools and created a proper Renviron.site file saying: MYSQL_HOME="C:/Program Files/MySQL/MySQL Server 5.5" When I try to install the packages from source, I get warnings that suggest I'm still not quite "with the

What do I need to do to load the RMySQL library on Win 2K using version 1.8.1 I have Mysql v4.0.16 up and running on the local machine with several databases running fine. Using RGUI I have loaded RMySQL and an appropriate directory structure has appeared under C:\Program Files\R\rw1081\library\RMySQL I have added C:\Program Files\R\rw1081\library\RMySQL\inst\libs to my path variable so that

Hi List, I'm running R2.5.1 on WinXP. Downloaded RMySQL_0.6-0.zip from http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.6/ and the installation seemed fine. However, when I tried to load the package, the error occured: > utils:::menuInstallLocal() package 'RMySQL' successfully unpacked and MD5 sums checked updating HTML package descriptions > library(RMySQL) Loading

Hi all, I am exploring the possibility of using R in my meteorological verification project. I have installed R on my Windows (XP) desktop machine and have also installed the RMySQL and verification packages. However, I run into problems when I try to load RMySQL. I get the following error: Error in fun(...) : MySQL is not installed according to a Registry search Error : .onLoad failed in

I have R 2.10.1 and 2.9.1 installed, and both have RMySQL packages installed. I script I'd developed using an older version (2.8.?, I think) used RMySQL too and an older version of MySQL (5.0.?), and worked fine at that time (about a year and a half ago +/- a month or two). But now, when I run it again, on new data, the script works fine until it is supposed to store its results in my DB.

Hello: What do I need to do to compile R packages (especially RMySQL) for the 64-bit version of R 2.12.0 under Vista_x64? I upgraded to "Rtools212.exe" yesterday but immediately got errors from "R CMD check RMySQL_0.7-5.tar.gz". After the first error, I installed it a second time, then got "undefined reference to" roughly 50 different names beginning

Hello, I'm tearing my hair out over this. Any help will be very much appreciated. It's been two long nights battling with RMySQL. > library(RMySQL) Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library "/usr/local/lib/R/library/RMySQL/libs/RMySQL.so": dlcompat: dyld: /usr/local/lib/R/bin/R.bin Undefined symbols: _getopt_long

Being relatively new to R, I want to use R in connection with a MySQL database. After installing (apparently sucessfully) the package RMySQL (R Version 1.6.2) the result is as follows: > library(RMySQL) > con <- dbConnect(MySQL(), dbname= "test") Error: couldn''t find function "dbConnect" Thank You in advance for help Peter Jörg Peter Baresel Technische

I am having trouble loading RMySQL after installing it. I have looked at archived r-help files and it seems many people have had issues, but I didn't find my specific issue. I also went to the webpage at Vanderbilt (http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL) and followed the instructions as best I understood them: - I created a file called Renviron.site under