search for: rmysql

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 Fil...

Hi, I have a problem loading RMySQL 0.5-5 on Mac OS 10.4.2 running R 2.1.1. I installed RMySQL using: export PKG_CPPFLAGS="-I/usr/local/mysql/include" export PKG_LIBS="-L/usr/local/mysql/lib -lmysqlclient" R CMD INSTALL /Users/gwo/Desktop/RMySQL_0.5-5.tar.gz The installation seemed to work ok, but when I load...

Hi, I am having problems loading RMySQL. I am using MySQL 5.0, R version 2.5.1, and RMySQL with Windows XP. When I try to load rMySQL I get the following error: > require(RMySQL) Loading required package: RMySQL Error in dyn.load(x, as.logical(local), as.logical(now)) : unable to load shared library 'C:/PROGRA~1/R/R-25~1....

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 Group, I'm having lots of problems getting RMySQL on a 64 bit machine. I followed all instructions available but couldn't get it working yet! Please help. See the output below. I did a install of RMySQL binary from the revolution cran source. It seems to have unpacked fine but gives this error when I call RMySQL Error: package 'RMySQL'...

I had installed R and MySQL ,then I input : > install.packages('RMySQL',type='source') show the message below, Why? Why shows "ERROR: configuration failed for package 'RMySQL'"? ??URL?http://mirrors.xmu.edu.cn/CRAN/src/contrib/RMySQL_0.9-3.tar.gz' Content type 'application/x-gzip' length 165363 bytes (161 Kb) ???URL downlo...

Hi R users, I have been trying to install and use RMySQL on Windows98 for MySQL3.23.55-max using the pulldown menu. I am getting the following errors. I read the doc and some archived mails about a similar problem on unix like systems. Still can't get it to work. Some info below that may indicated where the problem is: * The directory RMySQL\libs...

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 ...

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...

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 Error in library(RMySQL) : .First.lib...

Hallo! Thanks for the answers that I received. I had downloaded the last distribution of RMySQL from /R/CRAN/src/contrib/Devel.. Its the first package that I am trying to compile under Windows. >From the Compiler I am getting the following error message. In file included from RMySQL.c:1: RMySQL.h:24: mysql.h: No such file or directory RMySQL.h:25: mysql_com.h: No such file or directory ma...

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: fun(...) error: A MySQL Registry key was found but the folder C:\Program Files\MySQL\MySQL Tools for 5.0\/. doesn't contain a bin or lib/opt folder. That'...

Hello! I tried to build the RMySQL package by myself on an NT machine. I have a NT machine with cygwin compiler and activestate Perl installed on it. Perl details: D:\prog\rw1011\src\gnuwin32>perl -v This is perl, version 5.005_03 built for MSWin32-x86-object (with 1 registered patch, see perl -V for more detail) Copyright 1987-...

Dear forum, I'm trying to install RMySQL but I'm having problems in loading it, here is the message that I'm getting in R install.packages("RMySQL", dependencies=TRUE) trying URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/2.5/RMySQL_0.6-0.zip' Content type 'application/zip' length 391364 byte...

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_...

...tools215.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 then followed the steps described in http://stackoverflow.com/questions/4785933/adding-rmysql-package-to-r-fails, namely: 1. Install latest RTools from http://cran.r-project.org/bin/windows/Rtools/ 2. install MySQL or header and library files of mysql 3. create or edit file C:\Progra...

I'm having trouble getting RMySQL to load. I was able to build it and install it (RMySQL_0.5-11.tar.gz). I was also able to build and install mysql-5.0.37. I've read many postings about this but have not found a mention of my particular problem (some closely related). I get the "unable to load shared library, no suc...

I am having some trouble getting RMySQL installed. Thought there might be some ideas out there. The problem: MySQL 3.23.47 is installed (server,devel, client, benchmarks,shared) and seems to be working. R 1.4.0 is working. >On first install attempt I get : > >checking for mysql_init in -lmysqlclient... no >checking for...

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)...

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 Ban...