Re: [R] RMySQL DBI question

From: David James <daj025_at_gmail.com>
Date: Thu, 31 May 2007 21:29:44 -0400

Hi,

It would be helpful to have a small reproducible example. Do you see the same error if you run "R --save < whatever.R" from the shell prompt?

Regards,

--
David


On 5/31/07, Waverley <waverley.paloalto_at_gmail.com> wrote:

> Dear colleague,
>
> I have two data frame which I tried to use dbWriteTable function with
> append=TRUE to write to the mysql database.
>
> The problem is that if I am run my R script directly then it is fine. Both
> data frame got written into the database. But when I tried to embed the
> script to be called as system("R --save < whatever.R") in my perl script, I
> saw very strange things.
>
> One of the data frame got written into the database without any problem.
> But the other one refused to go to the database with the following error
> message:
>
> "Error in mysqlExecStatement ... RS-DBI driver: (could not run statement:
> Table ... already exists)
>
> I have checked on line and find
> http://tolstoy.newcastle.edu.au/R/help/01c/0652.html talks about the same
> problem I have en counted. But the problem is that I have two data frame,
> one works and the other does not. Also if I don't run under perl and run
> directly R under shell, both works.
>
> Can someone help?
>
> I am running R-2.5.0 with RMySQL-0.5-11 and DBI0.2.3.
>
> I am using linux redhat ES4.0 64 bit.
>
> --
> Waverley @ Palo Alto
>
> [[alternative HTML version deleted]]
>
> ______________________________________________
> R-help_at_stat.math.ethz.ch 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.
>
______________________________________________ R-help_at_stat.math.ethz.ch 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.
Received on Fri 01 Jun 2007 - 01:35:51 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 01 Jun 2007 - 02:31:40 GMT.

Mailing list information is available at https://stat.ethz.ch/mailman/listinfo/r-help. Please read the posting guide before posting to the list.