[R] RMySQL crashes R

[auburneconomics]

Duncan Murdoch-2 wrote:
> 
> On 1/12/2009 1:02 PM, auburneconomics wrote:
>> This is similar to another current post about RMySQL crashing R, except
>> on
>> the other post it crashed on connection to the database.  I can
>> successfully
>> connect, and even can do dbListTables().  But, if I send a query or
>> anything
>> to actually see the data, R crashes to desktop.  
>> 
>> I have tried this on two computers, one Vista, one XP.  Both crashed.  I
>> am
>> running 2.8.1, and am using the correct version of DBI and RMySQL.  They
>> are
>> both loaded with the library() function beforehand.  Versions of MySQL
>> that
>> it was tried are 5.1 and 6.0a.  
>> 
>> I have searched on the internet and haven't found any answers, and would
>> be
>> grateful for any help,
> 
> I'd recommend using RODBC instead.
> 
> The disadvantage is that you'll be at the mercy of whoever wrote the 
> ODBC driver, but I believe I've had good experience with the MySQL one.
> 
> Duncan Murdoch
> 
> ______________________________________________
> R-help at 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.
> 
> 

I was hoping to be able to alter a MySQL database within R, which would in
turn immediately update a web page written in PHP.  I am already well versed
in the MySQL/PHP stuff so it would be really neat if I could get this to
work... My hunch is that there is something in a setting somewhere that is
causing this.  I bet its something really stupid (as it always seems to be).

-- 
View this message in context: http://www.nabble.com/RMySQL-crashes-R-tp21419908p21421521.html
Sent from the R help mailing list archive at Nabble.com.