similar to: RMySQL and '_' character in column names

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 RMySQL in R I get an error message: >library(RMySQL)

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.1/library/RMySQL/libs/RMySQL.dll': LoadLibrary

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 downloaded 161 Kb *

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' is not installed for 'arch=x64'

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

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:

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

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

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

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 bytes opened URL downloaded 382Kb package 'RMySQL'

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-1999, Larry Wall Binary build 522 provided by ActiveState Tool

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 /usr/local/include/mysql/mysql.h... no >checking for

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

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, 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 installed 64bit R version 2.11.1 on 64bit Vista system and I have a problem with RMySQL package. I have installed 64bit verion of MySQL (5.1.47) and set MYSQL_HOME. Installation of package looks fine : >install.packages("RMySQL_0.7-4.zip") inferring 'repos = NULL' from the file name package 'RMySQL' successfully unpacked and MD5 sums checked but whet I try

Hi, I have installed 64bit R version 2.11.1 on 64bit Vista system and I have a problem with RMySQL package. I have installed 64bit verion of MySQL (5.1.47) and set MYSQL_HOME. Installation of package looks fine : >install.packages("RMySQL_0.7-4.zip") inferring 'repos = NULL' from the file name package 'RMySQL' successfully unpacked and MD5 sums checked but whet I try

Hi, I'm trying to get Rmysql to work o windows server 2008 64-bit. I have the latest build of mysql installed (mysql-5.1.34-winx64). When trying to load Rmysql, I got a warning that Rmysql is linking to an old-ish mysql build (5.0.67). I could do some basic stuff (the connection works) but it breaks when trying to read a large table. So I set up to use the buld 5.0.67 that Rmysql likes. 10

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