search for: mysql_home

...age 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 "etc" in the R folder. In it, I tried to put a pointer to where MySQL is. I tried: - MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQL~Server~5.5/ - MYSQL_HOME=C:/PROGRA~1/MySQL/MYSQLS~5.5/bin (which are guesses at how this should be written from the example on the webpage.) - MYSQL_HOME=C:/Program Files/MySQL/MySQL Server 5.5 (the actual location; n....

...whatever platform I happen to be using. I began by trying to follow the instructions provided on http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL, and found a couple issues. First, there was no Renviron.site in C:/Program Files/R/R-2.11.1-x64/etc so I made one and placed in it the following: MYSQL_HOME=C:\PROGRA~1\MySQL\MYSQLS~1.1 The full path to the installation of MySQL is: C:\Program Files\MySQL\MySQL Server 5.1 Unlike what is said on the biostat.mc.vanderbilt.edu pages, MYSQL_HOME is still empty: > Sys.getenv('MYSQL_HOME') MYSQL_HOME "" This is when I start R...

...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 set this environment variable on the windows path > Sys.getenv('MYSQL_HOME') MYSQL_HOME "C:/Program Files/MySQL/MySQL Server 5.0" > install.packages('RMySQL',type='source') trying URL 'http://cran.revolutionanalytics.com/src/contrib/RMySQL_0.7-5.tar.gz' Content type 'application/x-gzip' l...

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

...Win XP machine running R 2.15.1. I thought that RMySQL was the way to go. (Is there an easier way?) I tried to follow the instructions at http://www.r-bloggers.com/installing-the-rmysql-package-on-windows-7/ so I installed mysql-installer-community-5.5.27.0.msi, then set the environment variable MYSQL_HOME, and tried to install RMySQL within R. It failed, as shown below, but I can't see what is wrong. What's missing? If I only want to read tables from the database and work on them in R, is there an easier package? > Sys.getenv("MYSQL_HOME") [1] "C:\\Program Files\\MySQL\...

...n 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, saved to R\R-2.14.2\etc. My instances of common problems: Sys.getenv('MySQL_HOME') [1] "C:\Program Files\MySQL\MySQL Server 5.5\" install.packages('RMySQL', type = 'source') Installing package(s) ... .....

i m installing RMySQL under windows -7 64bit, i have wamp server(which has mysql5.5.16) i have given MYSQL_HOME path in environment variable as MYSQL_HOME=C:\wamp\bin\mysql\mysql5.5.16\bin , & also create Renviron.site file in C:\Program Files\R\R-2.15.0\etc giving MYSQL_HOME=C:/wamp/bin/mysql/mysql5.5.16/bin as path i install c connector "MySQL Connector C 6.0.2" version also, which has...

...://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:\Program Files\R\R-2.15\etc\Renviron.site and add line like MYSQL_HOME=C:/mysql (path to your mysql files) 4. copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies. 5. copy libmysql.dll to C:\Program Files\R\R-2.15\bin directory. 6. run install.packages('RMySQL',type='source') and wait while compilation will end. > install.packa...

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 program" yet. There are comments about POSIX paths that I don't quite grasp. Can anyone give me additional hints? Ther...

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: --------------------------------------------------------------- library(RMySQL) #ok drv = dbDriver("MySQL") # ok conn <- mysqlNewConnection(drv,&quo...

...e appears: http://cran.r-project.org/web/packages/RMySQL/INSTALL): > > 1. Download the RMySQL_0.9.tar.gz file to the folder C:\Program > Files\R\R-2.15.1\bin\x64 > 2. Open a Windows command line, and change directory to that folder > 3. Enter the following commands: > set MYSQL_HOME=C:\\Program Files\\MySQL\\MySQL Server 5.5 > R CMD INSTALL RMySQL_0.9.tar.gz BUT this message appears > grDevices::pdf.options(useDingbats = FALSE); utils::Sweave('proyecto1.Rnw', encoding='ISO8859-1') Writing to file proyecto1.tex Processing code chunks with opt...

...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 results in another table in MySQL. The very first thing I did in this session was execute the following two commands: Sys.setenv(MYSQL_HOME='c:/MySQL') library(RMySQL) The output I got was: Loading required package: DBI Warning message: In inDL(x, as.logical(local), as.logical(now), ...) : DLL attempted to change FPU control word from 8001f to 9001f Now, I write programs in relatively high level languages (C++, perl, Java,...

I have installed instant rails and configured it http://instantrails.rubyforge.org/wiki/wiki.pl?Getting_Started I can get typo and webrick to work on webrick localhost:3000 but cant get anything to work with scgi. When i start the scgi server i get a blank dos window screen. When i type www.mycookbook.com into the browser i get the following Unable to connect Firefox can''t

...nts/R/win-library/2.12? (as ?lib? is unspecified) trying URL 'http://lib.stat.cmu.edu/R/CRAN/src/contrib/RMySQL_0.7-5.tar.gz' Content type 'application/x-gzip' length 160769 bytes (157 Kb) opened URL downloaded 157 Kb * installing *source* package 'RMySQL' ... checking for $MYSQL_HOME... C:/Program Files/MySQL/MySQL Server 5.5 cygwin warning: MS-DOS style path detected: C:/Program Preferred POSIX equivalent is: /cygdrive/c/Program CYGWIN environment variable option "nodosfilewarning" turns off this warning. Consult the user's guide for more details about PO...

...lude"' "C:\\Users\\trendwise\\Downloads\\RMySQL_0.9-3.tar.gz" * installing to library 'C:/Users/trendwise/Documents/R/win-library/2.14' * installing *source* package 'RMySQL' ... ** package 'RMySQL' successfully unpacked and MD5 sums checked checking for $MYSQL_HOME... C:\Program Files\MySQL\MySQL Server 5.5\.; cygwin warning: MS-DOS style path detected: C:\Program Preferred POSIX equivalent is: /cygdrive/c/Program CYGWIN environment variable option "nodosfilewarning" turns off this warning. Consult the user's guide for more details about...

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 on MySQL C function load_defaults() as it was meant for command-line tools, not for (re)connecting to a database. * Fixed \r issue with dbWriteTable(). * Tests have been added and depend on proper values se...

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 on MySQL C function load_defaults() as it was meant for command-line tools, not for (re)connecting to a database. * Fixed \r issue with dbWriteTable(). * Tests have been added and depend on proper values se...

...em disappears. > > Best regards > > Erik J?rgensen > Faculty of Agricultural Sciences, > Aarhus University, > Denmark > > PS. R - version 2.8.1 - Windows XP Professional Service Pack3. I > specify the path to the DLL-file manually via the environment > variable MYSQL_HOME. > -- Brian D. Ripley, ripley at stats.ox.ac.uk Professor of Applied Statistics, http://www.stats.ox.ac.uk/~ripley/ University of Oxford, Tel: +44 1865 272861 (self) 1 South Parks Road, +44 1865 272866 (PA) Oxford OX1 3TG, UK...

..... ** package 'RMySQL' successfully unpacked and MD5 sums checked "tty" option detected in CYGWIN environment variable. CYGWIN=tty is no longer supported. Please remove it from your CYGWIN environment variable and use a terminal emulator like mintty, xterm, or rxvt. checking for $MYSQL_HOME... not found... searching registry... Error in readRegistry("SOFTWARE\\MySQL AB", hive = "HLM", maxdepth = 2) : Registry key 'SOFTWARE\MySQL AB' not found Execution halted ERROR: configuration failed for package 'RMySQL' * removing 'C:/Users/trendwise/Do...

Sorry for not taking care of this... If anyone would like to take over maintainership of RMySQL I'm sure the R community would greatly appreciate it. I just don't have the time these days. Jeff [[alternative HTML version deleted]]