similar to: RMySQL 0.7-2 now available on CRAN

For those R user's who don't subscribe to R-sig-db and are having troubles with the latest RMySQL binary on CRAN, please read the email thread at the end of this message. RMySQL 0.7-2 does work with MySQL 5.1, however the CRAN binary is linked against the 5.0 version. Best, Jeff -------- Original Message -------- Subject: Re: [R-sig-DB] Problems with RMySQL and MySQL server version

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,

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

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.

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

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

Hello, On a fresh install of Jessie, I achieve to make dovecot/postfix working with SQL, but I still can't send email to alias for wich one I get : "Unknown user" After debug enable in dovecot, I see that the user_query SQL , just query for the "users" table and not the "forward" table so the final alias user is not known. But when I check postfix for

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

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

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'

I have a 64 bit machine running 64 bit windows 7 pro, 64 bit MySQL, and 64 bit R 2.11.1. I have also installed RTools for 64 bit windows for this version of R (archive name is oldWin64toolchain.zip; the install path for its contents is C:\RTools, if that matters). I can open up a commandline window and invoke any of the programs in both bin directories (both added to the system path). There are

Hi, The problem was the row.names that were sent to the database and created an primary key duplicate. Now it works fine. BTW congratulations for the package. It copied 15300 rows by 11 columns in less than 5 seconds, in my PIII 833 with 1 GB RAM. > system.time(dbWriteTable(con, "TBL_SIMDATA", TBL.SIMDATA, append = TRUE, row.names=F)) [1] 3.87 0.05 4.86 0.01 0.00 Just one

I started a brand new session in R 2.10.1 (on Windows). If it matters, I am running the community edition of MySQL 5.0.67, and it is all running fine. I am just beginning to examine the process of getting timer series data from one table in MySQL, computing moving averages and computing a selection of estimates based on relations among moving averages of different variates, and storing all the

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. A colleague of mine figured out how to get the RMySQL 0.6 package to load properly in our environment with MySQL 5.0.45. Every time I tried to load the RMySQL library in R 2.5.1 I was getting an error message: LoadLibrary failure: Invalid access to memory location. We did the following: First obtain RMySQL 0.5-7, which can be found at

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

I have been having trouble getting RMySQL to work on Mac OS 10.4. It was working fine for me about a year ago but I didn't touch it for a while and several upgrades of R, MySQL, and OS X later, it is not working. I first had the problem that others have been having getting the error discussed in https://stat.ethz.ch/pipermail/r-sig-mac/2005- November/002435.html saying that

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: