Dear All, I am having a bit of problem using the DBI and RMySQL package. I have already installed DBI but now I want to connect to MySQL. So how do I do it. The CRAN package repository does not have RMySQL windows binary to install from? Regards, Indrajit Sen Gupta Business Analyst Mu Sigma Business Solutions Pvt Ltd #21/1-1, Nawab Towers Cunningham Road Bangalore 560 052, India Tel: +91 80 5123 2551 Fax: +91 80 5123 8853 Mob: +91 98807 54816 indrajit.sengupta at mu-sigma.com www.mu-sigma.com
On May 9, 2006, at 6:55 AM, Indrajit Sengupta wrote:> I am having a bit of problem using the DBI and RMySQL > package. I have already installed DBI but now I want > to connect to MySQL. So how do I do it. The CRAN > package repository does not have RMySQL windows binary > to install from?A while ago I setup a simple MySQL database, installed R, installed DBI and RMySQL, and ran a sample query. You can find my notes here: http://www.cwelug.org/cgi-bin/wiki.cgi?RMySQL HTH. Regards, - Robert http://www.cwelug.org/downloads Help others get OpenSource software. Distribute FLOSS for Windows, Linux, *BSD, and MacOS X with BitTorrent
Did you create RMySQL windows binary in the process? Can you share it with me? Regards, Indrajit --- Robert Citek <rwcitek at alum.calberkeley.org> wrote:> > On May 9, 2006, at 6:55 AM, Indrajit Sengupta wrote: > > I am having a bit of problem using the DBI and > RMySQL > > package. I have already installed DBI but now I > want > > to connect to MySQL. So how do I do it. The CRAN > > package repository does not have RMySQL windows > binary > > to install from? > > A while ago I setup a simple MySQL database, > installed R, installed > DBI and RMySQL, and ran a sample query. You can > find my notes here: > > http://www.cwelug.org/cgi-bin/wiki.cgi?RMySQL > > HTH. > > Regards, > - Robert > http://www.cwelug.org/downloads > Help others get OpenSource software. Distribute > FLOSS > for Windows, Linux, *BSD, and MacOS X with > BitTorrent > >
> I'll see if I can reproduce the steps under Knoppix[1]. Then you can > run Knoppix with a Persistent Disk Image (PDI)[2] that contains R, > the DBI, and RMySQL on just about any machine that runs Knoppix.Don't bother, it's been done already. See http://dirk.eddelbuettel.com/quantian.html> -----Original Message----- > From: r-help-bounces at stat.math.ethz.ch > [mailto:r-help-bounces at stat.math.ethz.ch] On Behalf Of Robert Citek > Sent: Thursday, May 11, 2006 11:08 AM > To: R-help at stat.math.ethz.ch > Subject: Re: [R] Using DBI and RMySQL > > > On May 11, 2006, at 3:09 AM, Indrajit Sengupta wrote: > > Did you create RMySQL windows binary in the process? > > Sorry, but no. This was done on Mac OS X. And was done a while ago. > > > Can you share it with me? > > Wish I could, but I can't. I don't have a Windows machine. > > I'll see if I can reproduce the steps under Knoppix[1]. Then > you can > run Knoppix with a Persistent Disk Image (PDI)[2] that contains R, > the DBI, and RMySQL on just about any machine that runs Knoppix. > > [1] http://knoppix.net/ > [2] http://knoppix.net/wiki/ > Customizing_environment_using_4.0.2CD#Persistent_Disk_Image_.28PDI.29 > > Regards, > - Robert > http://www.cwelug.org/downloads > Help others get OpenSource software. Distribute FLOSS > for Windows, Linux, *BSD, and MacOS X with BitTorrent > > ______________________________________________ > 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 >