similar to: Is there a version of RMySQL for Windows?

Hi R users, I am unable to load RMySQL. The zip file is not available which I guess is needed to load this pakage. I also tried extracting the package from RMySQL_0.5-11.tar.gz and then pasted the package in the directory where R is loaded for which I am getting the following error message "Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed <

I just installed RMySQL 0.5-9 with R 2.4.0 on Windows XP and got the following error message when trying to run a script with RMySQL: Error in library(RMySQL) : 'RMySQL' is not a valid package -- installed < 2.0.0? Any ideas? Thanks, Frank

Dear All, I am having a bit of problem using the DBI and RMySQL package. I have already installed DBI but now I want to connect to MySQL. So how do I do it. The CRAN package repository does not have RMySQL windows binary to install from? Regards, Indrajit Sen Gupta Business Analyst Mu Sigma Business Solutions Pvt Ltd #21/1-1, Nawab Towers Cunningham Road Bangalore 560 052, India Tel: +91 80

Folks, I failed to create a connection to the database under MySQL DBMS in the R system via RMySQL's method dbConnection(...). My setup is as follows: Microsoft Windows XP 5.1.2600 MySQL 4.1.9 R 2.0.1 DBI 0.1-8 RMySQL 0.5-5 Both of DBI and RMySQL packages were downloaded from bell lab: http://stat.bell-labs.com/RS-DBI/download/index.html My case in R is as follows: > library(DBI)

Hi, Whenever I have a MySQL query that returns a Decimal result to R I get the following warning in R: Warning message: RS-DBI driver warning: (unrecognized MySQL field type 246 in column 1) I get this for a simple query like "SELECT 2, 2.5" !! I am using: R ver 2.1.1 RMySQL ver. 0.5-7 DBI ver. 0.1-10 MySQL Ver 14.12 Distrib 5.0.18. Please Help! Jason

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

I get the following error trying to connect to a MySQL database: > library(RMySQL) Loading required package: DBI > drv<-dbDriver("MySQL") > con<-dbConnect(drv, user="hothand", password=xxx, host="localhost", dbname="hh03"); Error in mysqlNewConnection(drv, ...) : RS-DBI driver: (could not connect hothand at localhost on dbname

Dear R users, I would like to query a MySQL database through R. I have installed the latest required packages (RMySQL and DBI) in R (v2.3.1). A MySQL server (v5.0.22) is running on my local machine but I can't initialize MYSQL driver: ------------------------------------------------------------------------------------ > library("RMySQL") Loading required package: DBI >

Hi all, I have a very strange problem with the RMySql package. I'm running linux ubuntu 64 bit and R 2.14. I'm trying to solve this now for a week and could not find anything helpful on the net. Now the problem If I start my R script from php (script attached) the output is as followed Start R Script from php R version 2.14.1 (2011-12-22) Copyright (C) 2011 The R Foundation for

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

Hi, I have problems installing RMySQL under R1.8.1 and RHlinux (kernel2.4.7). During compilation I get: ** libs gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -m486 -fno-strength-reduce -g -c RS-DBI.c -o RS-DBI.o gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -D__NO_MATH_INLINES -mieee-fp -fPIC -O2 -m486

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

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

Hi all, Unfortunately I must use winXP at my job, so I'm trying install from source RMySQL. Here are some details about this problem: - R 1.7.1 - RMySQL 0.5-2 - mysql 4.1.0-alpha-max-nt I followed the instructions posted in http://www.biostat.jhsph.edu/~kbroman/Rintro/Rwinpack.html and the following messages appeared. BTW, thanks in advance for your help and comments. C:\Program

i was able to install DBI and RMySQL cleanly. I get the error below on "library('RMySQL')". The file it is complaining about is located in /usr/lib/mysql/, where is R trying to load it from? Tried a symlink into /usr/local/lib/mysql to no avail. thx. -P Loading required package: DBI Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared

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

I have been installing and using the RMySQL package, version 0.5-3 with R versions 1.9.0 and 1.9.1 on Windows XP without any problem. I installed the package using the .zip binary package available at http://stat.bell-labs.com/RS-DBI/download/index.html. However, I ran into a problem using this package with the latest version 2.0.0 of R. The installation went ok, but loading the library using

Full_Name: K?re Jonsson Version: 2.10 OS: WinXP Submission from: (NULL) (85.225.178.169) I made a brand new installation of R 2.10 in two machines and got the same problem. Machine 1 is Win XP on metal installation machine 2 is virtual in VMWare running a hacky OS named Tiny XP in which any Microsoft windows XP siftware always successfully is installed. Operation 1. Add package RMySQL from

I am having trouble installing RMySQL on a clean install of Fedora Core 4 64 bit on a dual dual core machine (that is, two dual core processors). Seems like the LD_LIBRARY_PATH is incorrect, but I don't seem to have it quite right yet. There are a few mentions of this problem in google, but thus far none of the "fixes" and fixed my problem. I've tried defining the

I am having trouble getting RMySQL working with R. It did at one point, work with an older 1.x version of R, but now with R2.2.1, I am getting the following messages on my OS X 10.4.5 system: RS-DBI driver warning: (MySQL mismatch between compiled version 4.0.24 and runtime version 4.1.14) if I then try to run any further db commands such as dbConnect, R crashes with a bus error. When