> Just to check, are you loading the package using > > library(RMySQL) > > before trying to use it? > > If so, is it giving you any errors?
Hi, It was my first attempt, but since it didn't work I tried the other suggested method. By the way, here is what I get: > install.packages("RMySQL") Installing package(s) into ‘/usr/local/lib/R/site-library’ (as ‘lib’ is unspecified) --- Please select a CRAN mirror for use in this session --- Loading Tcl/Tk interface ... done provo con l'URL 'http://cran.mirror.garr.it/mirrors/CRAN/src/contrib/RMySQL_0.9-3.tar.gz' Content type 'text/plain' length 165363 bytes (161 Kb) URL aperto ================================================== downloaded 161 Kb * installing *source* package ‘RMySQL’ ... ** package ‘RMySQL’ successfully unpacked and MD5 sums checked checking for gcc... gcc checking for C compiler default output file name... a.out checking whether the C compiler works... yes checking whether we are cross compiling... no checking for suffix of executables... checking for suffix of object files... o checking whether we are using the GNU C compiler... yes checking whether gcc accepts -g... yes checking for gcc option to accept ANSI C... none needed checking how to run the C preprocessor... gcc -E checking for compress in -lz... yes checking for getopt_long in -lc... yes checking for mysql_init in -lmysqlclient... no checking for egrep... grep -E checking for ANSI C header files... yes checking for sys/types.h... yes checking for sys/stat.h... yes checking for stdlib.h... yes checking for string.h... yes checking for memory.h... yes checking for strings.h... yes checking for inttypes.h... yes checking for stdint.h... yes checking for unistd.h... yes checking mysql.h usability... no checking mysql.h presence... no checking for mysql.h... no checking for mysql_init in -lmysqlclient... no checking for mysql_init in -lmysqlclient... no checking for mysql_init in -lmysqlclient... no checking for mysql_init in -lmysqlclient... no checking for mysql_init in -lmysqlclient... no checking for mysql_init in -lmysqlclient... no checking for mysql_init in -lmysqlclient... no checking /usr/local/include/mysql/mysql.h usability... no checking /usr/local/include/mysql/mysql.h presence... no checking for /usr/local/include/mysql/mysql.h... no checking /usr/include/mysql/mysql.h usability... no checking /usr/include/mysql/mysql.h presence... no checking for /usr/include/mysql/mysql.h... no checking /usr/local/mysql/include/mysql/mysql.h usability... yes checking /usr/local/mysql/include/mysql/mysql.h presence... yes checking for /usr/local/mysql/include/mysql/mysql.h... yes Configuration error: could not find the MySQL installation include and/or library directories. Manually specify the location of the MySQL libraries and the header files and re-run R CMD INSTALL. INSTRUCTIONS: 1. Define and export the 2 shell variables PKG_CPPFLAGS and PKG_LIBS to include the directory for header files (*.h) and libraries, for example (using Bourne shell syntax): export PKG_CPPFLAGS="-I<MySQL-include-dir>" export PKG_LIBS="-L<MySQL-lib-dir> -lmysqlclient" Re-run the R INSTALL command: R CMD INSTALL RMySQL_<version>.tar.gz 2. Alternatively, you may pass the configure arguments --with-mysql-dir=<base-dir> (distribution directory) or --with-mysql-inc=<base-inc> (where MySQL header files reside) --with-mysql-lib=<base-lib> (where MySQL libraries reside) in the call to R INSTALL --configure-args='...' R CMD INSTALL --configure-args='--with-mysql-dir=DIR' RMySQL_<version>.tar.gz ERROR: configuration failed for package ‘RMySQL’ * removing ‘/usr/local/lib/R/site-library/RMySQL’ * restoring previous ‘/usr/local/lib/R/site-library/RMySQL’ The downloaded source packages are in ‘/tmp/RtmpaJ2WeK/downloaded_packages’ Warning message: In install.packages("RMySQL") : installation of package ‘RMySQL’ had non-zero exit status Federico ______________________________________________ R-help@r-project.org mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide http://www.R-project.org/posting-guide.html and provide commented, minimal, self-contained, reproducible code.