similar to: Can RMySQL run on Windows using a remote MySQL server?

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 everyone, I am trying to install the RMySQL package under windows xp. I've got the MySQL installed on the computer (MySQL server 5.1). I went through the steps presented on the webpage http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL and googled around and still can't find the answer. With the command readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2) I

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:

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

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)

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

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 *

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

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'

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)

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

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

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