require(RMySQL)
help('MySQL')
then see the examples shown by the help page
At 9:12 PM -1200 3/9/05, Adriano von Sydow wrote:
Hi
I run Linux SuSE 9.1, with MSQL 4.0.18
I installed R 2.0.1 and it is working fine
I installed RM 0.5-5 package and verified all installed.packages (see below) but when I tried to use any RMySQL specific comand is gives me the same error messages
dbConnectError: Object "dbConnect" not found
It looks like the packages is not installed
Any ideas or help would be welcome Thanks, Popolito
*** INSTALL *****
ginossauro:/home/avonsydow/Download/Stats # R CMD INSTALL RMySQL_0.5-5.tar.gz
* Installing *source* package 'RMySQL' ...
creating cache ./config.cache
checking how to run the C preprocessor... cc -E
checking for compress in -lz... yes
checking for getopt_long in -lc... yes
checking for mysql_init in -lmysqlclient... yes
checking for mysql.h... no
checking for /usr/local/include/mysql/mysql.h... no
checking for /usr/include/mysql/mysql.h... yes
updating cache ./config.cache
creating ./config.status
creating src/Makevars
** libs
gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -I/opt/gnome/
include -fPIC -c RS-DBI.c -o RS-DBI.o
gcc -I/usr/lib/R/include -I/usr/include/mysql -I/usr/local/include -I/opt/gnome/
include -fPIC -c RS-MySQL.c -o RS-MySQL.o
gcc -shared -L/usr/local/lib -L/opt/gnome/lib -o RMySQL.so RS-DBI.o RS-MySQL.o -
lmysqlclient -lz -L/usr/lib/R/lib -lR
** R
** inst
** save image
Loading required package: DBI
[1] "dbObjectId"
[1] "format"
[1] "show"
[1] "print"
[1] "MySQLObject"
[1] "MySQLDriver"
[1] "dbUnloadDriver"
[1] "dbGetInfo"
[1] "dbListConnections"
[1] "summary"
[1] "MySQLConnection"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbConnect"
[1] "dbDisconnect"
[1] "dbSendQuery"
[1] "dbGetQuery"
[1] "dbGetException"
[1] "dbGetInfo"
[1] "dbListResults"
[1] "summary"
[1] "dbListTables"
[1] "dbReadTable"
[1] "dbWriteTable"
[1] "dbExistsTable"
[1] "dbRemoveTable"
[1] "dbListFields"
[1] "dbCommit"
[1] "dbRollback"
[1] "dbCallProc"
[1] "MySQLResult"
[1] "dbClearResult"
[1] "fetch"
[1] "fetch"
[1] "dbGetInfo"
[1] "dbGetStatement"
[1] "dbListFields"
[1] "dbColumnInfo"
[1] "dbGetRowsAffected"
[1] "dbGetRowCount"
[1] "dbHasCompleted"
[1] "dbGetException"
[1] "summary"
[1] "dbDataType"
[1] "make.db.names"
[1] "SQLKeywords"
[1] "isSQLKeyword"
[1] "dbApply"
[1] "dbApply"
** help >>> Building/Updating help pages for package 'RMySQL' Formats: text html latex example MySQL text html latex example MySQLConnection-class text html latex example MySQLDriver-class text html latex example MySQLObject-class text html latex example MySQLResult-class text html latex example S4R text html latex dbApply-methods text html latex example dbApply text html latex example dbCallProc-methods text html latex dbCommit-methods text html latex example dbConnect-methods text html latex example dbDataType-methods text html latex example dbDriver-methods text html latex example dbGetInfo-methods text html latex example dbListTables-methods text html latex example dbObjectId-class text html latex example dbReadTable-methods text html latex example dbSendQuery-methods text html latex example dbSetDataMappings-methods text html latex example fetch-methods text html latex example isIdCurrent text html latex example make.db.names-methods text html latex example mysqlDBApply text html latex example mysqlSupport text html latex safe.write text html latex example summary-methods text html latex * DONE (RMySQL)
*****INSTALLED.PACKAGES *******
installed.packages()Package LibPath Version Priority Bundle base "base" "/usr/lib/R/library" "2.0.1" "base" NA boot "boot" "/usr/lib/R/library" "1.2-20" "recommended" NA class "class" "/usr/lib/R/library" "7.2-10" "recommended" "VR" cluster "cluster" "/usr/lib/R/library" "1.9.6" "recommended" NA datasets "datasets" "/usr/lib/R/library" "2.0.1" "base" NA DBI "DBI" "/usr/lib/R/library" "0.1-8" NA NA foreign "foreign" "/usr/lib/R/library" "0.8-0" "recommended" NA graphics "graphics" "/usr/lib/R/library" "2.0.1" "base" NA grDevices "grDevices" "/usr/lib/R/library" "2.0.1" "base" NA grid "grid" "/usr/lib/R/library" "2.0.1" "base" NA KernSmooth "KernSmooth" "/usr/lib/R/library" "2.22-14" "recommended" NA lattice "lattice" "/usr/lib/R/library" "0.10-14" "recommended" NA MASS "MASS" "/usr/lib/R/library" "7.2-10" "recommended" "VR" methods "methods" "/usr/lib/R/library" "2.0.1" "base" NA mgcv "mgcv" "/usr/lib/R/library" "1.1-8" "recommended" NA nlme "nlme" "/usr/lib/R/library" "3.1-53" "recommended" NA nnet "nnet" "/usr/lib/R/library" "7.2-10" "recommended" "VR" RMySQL "RMySQL" "/usr/lib/R/library" "0.5-5" NA NA rpart "rpart" "/usr/lib/R/library" "3.1-20" "recommended" NA spatial "spatial" "/usr/lib/R/library" "7.2-10" "recommended" "VR" splines "splines" "/usr/lib/R/library" "2.0.1" "base" NA stats "stats" "/usr/lib/R/library" "2.0.1" "base" NA stats4 "stats4" "/usr/lib/R/library" "2.0.1" "base" NA survival "survival" "/usr/lib/R/library" "2.15" "recommended" NA tcltk "tcltk" "/usr/lib/R/library" "2.0.1" "base" NA tools "tools" "/usr/lib/R/library" "2.0.1" "base" NA utils "utils" "/usr/lib/R/library" "2.0.1" "base" NA Depends base NA boot "R (>= 2.0.0), graphics, stats" class "R (>= 2.0.0), graphics, stats" cluster "R (>= 1.9), stats, graphics, utils" datasets NA DBI "R (>= 1.7.1), methods" foreign "R (>= 2.0.0)" graphics "grDevices" grDevices NA grid "grDevices" KernSmooth "R (>= 1.9.0)" lattice "R (>= 2.0.0)" MASS "R (>= 2.0.0), graphics, stats" methods NA mgcv "R (>= 1.9.0)" nlme "graphics, stats, R(>= 2.0.0)" nnet "R (>= 2.0.0), graphics, stats" RMySQL "R (>= 1.8.0), methods, DBI (>= 0.1-4)" rpart "R (>= 2.0.0)" spatial "R (>= 2.0.0), graphics, stats" splines NA stats NA stats4 "graphics, stats, methods" survival "stats, utils, graphics, splines, R (>= 2.0.0)" tcltk NA tools NA utils NA Suggests base NA boot "survival" class "lattice, nlme, survival" cluster NA datasets NA DBI NA foreign NA graphics NA grDevices NA grid "lattice" KernSmooth "MASS" lattice "grid" MASS "lattice, nlme, survival" methods NA mgcv "nlme (>= 3.1-52), MASS (>= 7.2-2)" nlme NA nnet "lattice, nlme, survival" RMySQL NA rpart "survival" spatial "lattice, nlme, survival" splines NA stats NA stats4 NA survival NA tcltk NA tools NA utils NA
______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
-- -------------------------------------- Don MacQueen Environmental Protection Department Lawrence Livermore National Laboratory Livermore, CA, USA
______________________________________________ [email protected] mailing list https://stat.ethz.ch/mailman/listinfo/r-help PLEASE do read the posting guide! http://www.R-project.org/posting-guide.html
