I am trying to read a table from MySQL, I have loaded the file in "ts"
database, in table name ACC. but i am unable to read it in R through
getSymbol function.
mysql> show databases;
+--------------------------------+
| Database |
+--------------------------------+
| information_schema |
| mysql |
| test |
| ts |
+--------------------------------+
mysql> use ts;
Database changed
mysql> show tables;
+--------------------+
| Tables_in_ts |
+--------------------+
| ACC |
+--------------------+
mysql> select * from ACC;
+------------------------------+------------+---------+-------------+------------+-------------+
| Date | Open | High | Low | Close |
Volume |
+------------------------------+------------+---------+-------------+------------+-------------+
| 2006-11-30 09:55:00 | 1140 | 1150 | 1140 | 1150 | 33
|
| 2006-11-30 09:56:00 | 1149.9 | 1153 | 1149.9 | 1150 | 3195 |
| 2006-11-30 09:57:00 | 1148 | 1150 | 1147 | 1147.25 | 3669 |
| 2006-11-30 09:58:00 | 1148 | 1148 | 1145.45 | 1146 | 1982 |
I created the database after becoming super user, without user name and
password,
up-till here everything is fine.
library(quantmod)
library(RMySQL)
con <- dbConnect("MySQL",dbname ="ts")
data <- dbReadTable(con,"ACC")
tdata=(xts(data[,-1], as.POSIXct(data[,1])))
*barChart(tdata)*
dbDisconnect(con)
This thing works fine. I mean if done through DBI and RMySQL basic command,
then table
get read properly and I get a wonderful chart.
But doing it through getSymbol is giving problem.
*first i tried *
setDefaults(getSymbols.MySQL, dbname='ts')
getSymbols('ACC',src='MySQL')
Error in getSymbols.MySQL(Symbols = "ACC", env = <environment>, verbose =
FALSE, :
At least one connection argument ( user password dbname ) is not set
*second i tried *
setDefaults(getSymbols.MySQL,user=' ',password=' ',dbname='ts')
getSymbols('ACC',src='MySQL')
Error in mysqlExecStatement(conn, statement, ...) :
RS-DBI driver: (could not run statement: Unknown column 'o' in 'field
list')
*third i tried this *
setDefaults(getSymbols.MySQL,user='', password='', dbname='ts',
db.fields=c("Date","Open","High","Low","Close","Volume"))
getSymbols('ACC',src='MySQL')
Error in mysqlExecStatement(conn, statement, ...) :
RS-DBI driver: (could not run statement: FUNCTION ts.c does not exist)
I know i am doing something wrong but, i am really not able to figure out
what and where.
Please help me.
[[alternative HTML version deleted]]
______________________________________________
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.
