Hello, Please forget me if I am asking something that is well documented. I have read documentation but there are points that are not clear for me. I am not expert in R nor Databases, but if someone direct me to a tutorial, I will appreciate it.. 1. In my understanding, I can install and use RMySQL withouth having to install MySQL in my PC, to have access to and to create new tables . Is this right? 2. I have created a c:\my.cnf file to access a database I have, but withouth installing the server, where I can define the user, password and host to establish a connection? Thanks in advance ------------------------------------------------------------------- Jorge de la Vega Gongora | Telefono: (525) 5268 8379 Investigador | Fax: (525) 5268 8481 Banco de Mexico | email: jvega at banxico.org.mx Planeaci?n y Programaci?n de Emisi?n | web: http://www.stat.umn.edu/~jvega Calzada Legaria 691 M?dulo IV | Col. Irrigaci?n 11500 |
1. No way. You must have MySQL installed on your computer. 2. You must install the server. For details, see http://dev.mysql.com/doc/mysql/en/index.html . For portability, I would suggest that you run MySQL in the shell (ignore the GUIs) and save the syntax for adding users, creating tables etc. This will likely take more time when you first do it, but if you have to move to another computer later on, you can setup the new MySQL installation very quickly and easily. hth, b. -----Original Message----- From: De la Vega Góngora Jorge [mailto:jvega at banxico.org.mx] Sent: Friday, March 18, 2005 11:58 AM To: r-help at stat.math.ethz.ch Subject: [R] Basic questions about RMySQL Hello, Please forget me if I am asking something that is well documented. I have read documentation but there are points that are not clear for me. I am not expert in R nor Databases, but if someone direct me to a tutorial, I will appreciate it.. 1. In my understanding, I can install and use RMySQL withouth having to install MySQL in my PC, to have access to and to create new tables . Is this right? 2. I have created a c:\my.cnf file to access a database I have, but withouth installing the server, where I can define the user, password and host to establish a connection? Thanks in advance ------------------------------------------------------------------- Jorge de la Vega Gongora | Telefono: (525) 5268 8379 Investigador | Fax: (525) 5268 8481 Banco de Mexico | email: jvega at banxico.org.mx Planeación y Programación de Emisión | web: http://www.stat.umn.edu/~jvega Calzada Legaria 691 Módulo IV | Col. Irrigación 11500 | ______________________________________________ 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
> 1. No way. You must have MySQL installed on your computer.In fact this is not true. You can use a MySQL server installed somewhere else on the network. --- bogdan romocea <br44114 at yahoo.com> wrote:> 1. No way. You must have MySQL installed on your computer. > > 2. You must install the server. For details, see > http://dev.mysql.com/doc/mysql/en/index.html . > For portability, I would suggest that you run MySQL in the shell > (ignore the GUIs) and save the syntax for adding users, creating > tables > etc. This will likely take more time when you first do it, but if you > have to move to another computer later on, you can setup the new > MySQL > installation very quickly and easily. > > hth, > b. > > > -----Original Message----- > From: De la Vega Góngora Jorge [mailto:jvega at banxico.org.mx] > Sent: Friday, March 18, 2005 11:58 AM > To: r-help at stat.math.ethz.ch > Subject: [R] Basic questions about RMySQL > > > Hello, > > Please forget me if I am asking something that is well documented. I > have read documentation but there are points that are not clear for > me. > I am not expert in R nor Databases, but if someone direct me to a > tutorial, I will appreciate it.. > > 1. In my understanding, I can install and use RMySQL withouth having > to install MySQL in my PC, to have access to and to create new tables > . > Is this right? > > 2. I have created a c:\my.cnf file to access a database I have, but > withouth installing the server, where I can define the user, password > and host to establish a connection? > > Thanks in advance > > > ------------------------------------------------------------------- > Jorge de la Vega Gongora | Telefono: (525) 5268 8379 > Investigador | Fax: (525) 5268 8481 > Banco de Mexico | email: jvega at banxico.org.mx > Planeación y Programación de Emisión | web: > http://www.stat.umn.edu/~jvega > Calzada Legaria 691 Módulo IV | > Col. Irrigación 11500 | > > ______________________________________________ > 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 > > > __________________________________ >
bogdan romocea wrote:> 1. No way. You must have MySQL installed on your computer. > > 2. You must install the server. For details, see > http://dev.mysql.com/doc/mysql/en/index.html . > For portability, I would suggest that you run MySQL in the shell > (ignore the GUIs) and save the syntax for adding users, creating tables > etc. This will likely take more time when you first do it, but if you > have to move to another computer later on, you can setup the new MySQL > installation very quickly and easily.Can you tell us any reason why the server should run on the same machine R is running on? Uwe Ligges> hth, > b. > > > -----Original Message----- > From: De la Vega G?ngora Jorge [mailto:jvega at banxico.org.mx] > Sent: Friday, March 18, 2005 11:58 AM > To: r-help at stat.math.ethz.ch > Subject: [R] Basic questions about RMySQL > > > Hello, > > Please forget me if I am asking something that is well documented. I > have read documentation but there are points that are not clear for me. > I am not expert in R nor Databases, but if someone direct me to a > tutorial, I will appreciate it.. > > 1. In my understanding, I can install and use RMySQL withouth having > to install MySQL in my PC, to have access to and to create new tables . > Is this right? > > 2. I have created a c:\my.cnf file to access a database I have, but > withouth installing the server, where I can define the user, password > and host to establish a connection? > > Thanks in advance > > > ------------------------------------------------------------------- > Jorge de la Vega Gongora | Telefono: (525) 5268 8379 > Investigador | Fax: (525) 5268 8481 > Banco de Mexico | email: jvega at banxico.org.mx > Planeaci?n y Programaci?n de Emisi?n | web: > http://www.stat.umn.edu/~jvega > Calzada Legaria 691 M?dulo IV | > Col. Irrigaci?n 11500 | > > ______________________________________________ > 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 > > ______________________________________________ > 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
I certainly can't; I initially misunderstood the question.
If connecting to MySQL is the problem, then you need to know the user
ID, the domain and the password. Ask your DB administrator for help.
Here's an example that works for me (local MySQL installation):
require(DBI)
require(RMySQL)
MySQL(max.con = 16, fetch.default.rec = 5000, force.reload = F)
drv <- dbDriver("MySQL")
con <-
dbConnect(drv,username="userid",password="pswd",dbname="db")
dbListTables(con)
--- Uwe Ligges <ligges at statistik.uni-dortmund.de>
wrote:> bogdan romocea wrote:
>
> > 1. No way. You must have MySQL installed on your computer.
> >
> > 2. You must install the server. For details, see
> > http://dev.mysql.com/doc/mysql/en/index.html .
> > For portability, I would suggest that you run MySQL in the shell
> > (ignore the GUIs) and save the syntax for adding users, creating
> tables
> > etc. This will likely take more time when you first do it, but if
> you
> > have to move to another computer later on, you can setup the new
> MySQL
> > installation very quickly and easily.
>
> Can you tell us any reason why the server should run on the same
> machine
> R is running on?
>
> Uwe Ligges
>
>
> > hth,
> > b.
> >
> >
> > -----Original Message-----
> > From: De la Vega Góngora Jorge [mailto:jvega at banxico.org.mx]
> > Sent: Friday, March 18, 2005 11:58 AM
> > To: r-help at stat.math.ethz.ch
> > Subject: [R] Basic questions about RMySQL
> >
> >
> > Hello,
> >
> > Please forget me if I am asking something that is well documented.
> I
> > have read documentation but there are points that are not clear for
> me.
> > I am not expert in R nor Databases, but if someone direct me to a
> > tutorial, I will appreciate it..
> >
> > 1. In my understanding, I can install and use RMySQL withouth
> having
> > to install MySQL in my PC, to have access to and to create new
> tables .
> > Is this right?
> >
> > 2. I have created a c:\my.cnf file to access a database I have,
> but
> > withouth installing the server, where I can define the user,
> password
> > and host to establish a connection?
> >
> > Thanks in advance
> >
> >
> > -------------------------------------------------------------------
> > Jorge de la Vega Gongora | Telefono: (525) 5268 8379
> > Investigador | Fax: (525) 5268 8481
> > Banco de Mexico | email: jvega at banxico.org.mx
> > Planeación y Programación de Emisión | web:
> > http://www.stat.umn.edu/~jvega
> > Calzada Legaria 691 Módulo IV |
> > Col. Irrigación 11500 |
> >
> > ______________________________________________
> > 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
> >
> > ______________________________________________
> > 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
>
>
Thanks for your help. having MySQL server locally (or in some other place)
should solve the configuration problem.
By the way, I should have written forgive, no forget. Forgive me.
Jorge de la Vega
-----Mensaje original-----
De: bogdan romocea [mailto:br44114 at yahoo.com]
Enviado el: Viernes, 18 de Marzo de 2005 01:11 PM
Para: Uwe Ligges; De la Vega G?ngora Jorge
CC: r-help at stat.math.ethz.ch
Asunto: Re: [R] Basic questions about RMySQL
I certainly can't; I initially misunderstood the question.
If connecting to MySQL is the problem, then you need to know the user ID, the
domain and the password. Ask your DB administrator for help.
Here's an example that works for me (local MySQL installation):
require(DBI)
require(RMySQL)
MySQL(max.con = 16, fetch.default.rec = 5000, force.reload = F) drv <-
dbDriver("MySQL") con <-
dbConnect(drv,username="userid",password="pswd",dbname="db")
dbListTables(con)
--- Uwe Ligges <ligges at statistik.uni-dortmund.de>
wrote:> bogdan romocea wrote:
>
> > 1. No way. You must have MySQL installed on your computer.
> >
> > 2. You must install the server. For details, see
> > http://dev.mysql.com/doc/mysql/en/index.html . For portability, I
> > would suggest that you run MySQL in the shell (ignore the GUIs) and
> > save the syntax for adding users, creating
> tables
> > etc. This will likely take more time when you first do it, but if
> you
> > have to move to another computer later on, you can setup the new
> MySQL
> > installation very quickly and easily.
>
> Can you tell us any reason why the server should run on the same
> machine R is running on?
>
> Uwe Ligges
>
>
> > hth,
> > b.
> >
> >
> > -----Original Message-----
> > From: De la Vega G?ngora Jorge [mailto:jvega at banxico.org.mx]
> > Sent: Friday, March 18, 2005 11:58 AM
> > To: r-help at stat.math.ethz.ch
> > Subject: [R] Basic questions about RMySQL
> >
> >
> > Hello,
> >
> > Please forget me if I am asking something that is well documented.
> I
> > have read documentation but there are points that are not clear for
> me.
> > I am not expert in R nor Databases, but if someone direct me to a
> > tutorial, I will appreciate it..
> >
> > 1. In my understanding, I can install and use RMySQL withouth
> having
> > to install MySQL in my PC, to have access to and to create new
> tables .
> > Is this right?
> >
> > 2. I have created a c:\my.cnf file to access a database I have,
> but
> > withouth installing the server, where I can define the user,
> password
> > and host to establish a connection?
> >
> > Thanks in advance
> >
> >
> > -------------------------------------------------------------------
> > Jorge de la Vega Gongora | Telefono: (525) 5268 8379
> > Investigador | Fax: (525) 5268 8481
> > Banco de Mexico | email: jvega at banxico.org.mx
> > Planeaci?n y Programaci?n de Emisi?n | web:
> > http://www.stat.umn.edu/~jvega
> > Calzada Legaria 691 M?dulo IV |
> > Col. Irrigaci?n 11500 |
> >
> > ______________________________________________
> > 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
> >
> > ______________________________________________
> > 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
>
>
__________________________________
De la Vega G?ngora Jorge wrote:>Hello, > >Please forget me if I am asking something that is well documented. I have read documentation but there are points that are not clear for me. I am not expert in R nor Databases, but if someone direct me to a tutorial, I will appreciate it.. > > 1. In my understanding, I can install and use RMySQL withouth having to install MySQL in my PC, to have access to and to create new tables . Is this right? > >I doubt very mucg if RMySQP will be of any use without having MySQL installed! Kjetil> 2. I have created a c:\my.cnf file to access a database I have, but withouth installing the server, where I can define the user, password and host to establish a connection? > >Thanks in advance > > >------------------------------------------------------------------- >Jorge de la Vega Gongora | Telefono: (525) 5268 8379 >Investigador | Fax: (525) 5268 8481 >Banco de Mexico | email: jvega at banxico.org.mx >Planeaci?n y Programaci?n de Emisi?n | web: http://www.stat.umn.edu/~jvega >Calzada Legaria 691 M?dulo IV | >Col. Irrigaci?n 11500 | > >______________________________________________ >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 > > > > >-- Kjetil Halvorsen. Peace is the most effective weapon of mass construction. -- Mahdi Elmandjra -- No virus found in this outgoing message. Checked by AVG Anti-Virus.