R help - Feb 2009 - Help with R and MySQL

Hello,

This forum has been very helpful to me in the past, and I've run out of
ideas on how to solve my problem.

I had been using R and MySQL (and Perl) together for quite some time
successfully on my Windows XP machine. However, I recently had some problems
with MySQL (the ibdata file had become 35GB on my hard drive, turns out it's
a known bug with InnoDB), and ultimately the way I fixed my problem with MySQL
was to upgrade it.  It's working fine now, I can use MySQL however I'd
like.  I'm sticking to MyISAM tables for now, though.

However, I had set up my system so I did a linear regression in R. Originally,
this was done in R 2.5.0, I would load in the tables from MySQL to R and then
conduct the regression in R.  However, after solving my MySQL problem, I ran
into a strange error in R (and DBI/RMySQL).  R connected to the database just
fine, and I could even show the tables in the database and load two of them into
R.  However, the tables I loaded successfully were only a single column.  Every
time I tried to load in a recordset that was multiple columns, I got a
relatively nondescript Windows error("R for Windows terminal front-end has
encountered a problem and needs to close.  We are sorry for the
inconvenience.").  To verify that it wasn't a memory issue,  I even
tried "rs <- dbSendQuery(con, "select 'a',
'b'")".  This statement causes the error as well.

I tried upgrading the packages, and upgrading R from 2.5.0 to 2.8.1.  However, I
still get the same errors.  Has anyone run into this problem before?  Any
suggestions on how to solve it?

Thanks in advance,
Aaron


      
	[[alternative HTML version deleted]]

Aaron Barzilai wrote:
> Hello,
> 
> This forum has been very helpful to me in the past, and I've run out of
ideas on how to solve my problem.
> 
> I had been using R and MySQL (and Perl) together for quite some time
successfully on my Windows XP machine. However, I recently had some problems
with MySQL (the ibdata file had become 35GB on my hard drive, turns out it's
a known bug with InnoDB), and ultimately the way I fixed my problem with MySQL
was to upgrade it.  It's working fine now, I can use MySQL however I'd
like.  I'm sticking to MyISAM tables for now, though.
> 
> However, I had set up my system so I did a linear regression in R.
Originally, this was done in R 2.5.0, I would load in the tables from MySQL to R
and then conduct the regression in R.  However, after solving my MySQL problem,
I ran into a strange error in R (and DBI/RMySQL).  R connected to the database
just fine, and I could even show the tables in the database and load two of them
into R.  However, the tables I loaded successfully were only a single column. 
Every time I tried to load in a recordset that was multiple columns, I got a
relatively nondescript Windows error("R for Windows terminal front-end has
encountered a problem and needs to close.  We are sorry for the
inconvenience.").  To verify that it wasn't a memory issue,  I even
tried "rs <- dbSendQuery(con, "select 'a',
'b'")".  This statement causes the error as well.
> 
> I tried upgrading the packages, and upgrading R from 2.5.0 to 2.8.1. 
However, I still get the same errors.  Has anyone run into this problem before? 
Any suggestions on how to solve it?

Hi Aaron,

Be sure to read the details of the RMySQL web page:

http://biostat.mc.vanderbilt.edu/RMySQL

You need to make sure and match the version of your MySQL client library 
(not the running MySQL server) with the RMySQL binary that you choose 
from the web page above.

Best,

Jeff
-- 
http://biostat.mc.vanderbilt.edu/JeffreyHorner