similar to: Problems with RMySQL and MySQL server version 5.1

Dear R users, RMySQL 0.7-2 is now available on CRAN: http://cran.r-project.org/web/packages/RMySQL/index.html From the NEWS file: * New maintainer is Jeffrey Horner <jeff.horner at vanderbilt.edu>. * We no longer distribute libmysql.dll. This library is now found either by reading the MYSQL_HOME environment variable or by reading the windows registry entries. * Removed dependence

Dear R users, RMySQL 0.7-2 is now available on CRAN: http://cran.r-project.org/web/packages/RMySQL/index.html From the NEWS file: * New maintainer is Jeffrey Horner <jeff.horner at vanderbilt.edu>. * We no longer distribute libmysql.dll. This library is now found either by reading the MYSQL_HOME environment variable or by reading the windows registry entries. * Removed dependence

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

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

Full_Name: Apfel Schmied Version: 2.8.1 (2008-12-22) OS: WinXP SP2 Submission from: (NULL) (134.106.122.139) RMySQL Version: 0.7-2 DBI Version: 0.2-4 MySQL Version: 5.1.30 (Enviroment Variable MYSQL_HOME is set) Updated R from 2.60 to 2.8.1. Now Gui.exe hangs up (100% CPU Useage) when requesting data from a mysql database. Example Code:

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'

Hello, [This is a re-posting of a previous announcement; I believe the original posting of a couple of days ago didn't go through.] The latest version of RMySQL 0.6-1 is now in CRAN. Please see the NEWS file for more details. Also, I'm happy to announce that Jeff Horner <jeff.horner at vanderbilt.edu> has kindly agreed to maintain RMySQL from now on. Please continue sending your

Hello, [This is a re-posting of a previous announcement; I believe the original posting of a couple of days ago didn't go through.] The latest version of RMySQL 0.6-1 is now in CRAN. Please see the NEWS file for more details. Also, I'm happy to announce that Jeff Horner <jeff.horner at vanderbilt.edu> has kindly agreed to maintain RMySQL from now on. Please continue sending your

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

I'm currently working on embedding R into the Apache2 webserver (with some positive results...), but I'm struggling to identify the best way to expose the apache data and functions to R. A couple of thoughts: In light of the recent discussion on "S3/S4 classes performance comparson", I'm leaning toward implementing the interface with S3 style classes. I appreciate

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

when i am installing package manually (using below command) i get error about cygwin as, > install.packages("C:\\Users\\trendwise\\Downloads\\RMySQL_0.9-3.tar.gz",lib=getOption("lib"), > repos = NULL, type="source") error:------> Installing package(s) into ?C:/Users/trendwise/Documents/R/win-library/2.15? (as ?lib? is unspecified) * installing *source*

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, Can somebody advice on weird mysqlWriteTable bug. > mysqlWriteTable(conn, 'comparison',design2, row.names = F, overwrite=T) Error in mysqlExecStatement(conn, statement, ...) : RS-DBI driver: (could not run statement: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '"condition"

Dear R users, RMySQL 0.7-3 has been released. Expect it to hit the CRAN mirrors shortly, but in the mean time please get it here: http://biostat.mc.vanderbilt.edu/RMySQL From the NEWS file: Version 0.7-3 * Added mysqlClientLibraryVersions() which returns the compiled and loaded client library versions as a vector. * RMySQL will now check for MySQL minor version consistency and throw

Dear R users, RMySQL 0.7-3 has been released. Expect it to hit the CRAN mirrors shortly, but in the mean time please get it here: http://biostat.mc.vanderbilt.edu/RMySQL From the NEWS file: Version 0.7-3 * Added mysqlClientLibraryVersions() which returns the compiled and loaded client library versions as a vector. * RMySQL will now check for MySQL minor version consistency and throw