Connection with MySQL usin RMySQL package

4 messages · Christophe Dutang, Jim Burke, Brian Ripley +1 more

Sun, Feb 22, 2009 4:46 AM #

I think there is problem of compatibility between the MySQL version  
5.0 and RMySQL. I think you should use MySQL 5.1. Take a look to https://stat.ethz.ch/pipermail/r-sig-db/2008q4/000520.html


Le 22 f?vr. 09 ? 12:57, Khalid Iqbal a ?crit :

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

--
Christophe Dutang
Ph. D. student at ISFA, Lyon, France
website: http://dutangc.free.fr

--
Christophe Dutang
Ph. D. student at ISFA, Lyon, France
website: http://dutangc.free.fr

Jim Burke

Sun, Feb 22, 2009 11:50 AM #

Everyone,

Two things that might help. First the version of your computer when
connecting. Second how to connect. Also I do not think that MYSQL 5.1
will work with R at as of today 22.02.2009.

MY PC VERSIONS THAT **DID NOT WORK** ARE BELOW
----------------------------------------------

OPERATING SYSTEM INFORMATION
----------------------------
OS..........: Win XP sp3
R...........: 2.8.1
RMySQL.dll..: 0.7-3
MYSQL.......: 5.31 (problem, has new version of libmySQL.dll that does
not work in R yet).
libmySQL.dll: 1/23/2009 3:45am

My SOLUTION from Jeffrey Horner was to roll back to MYSQL 5.0 which
worked just fine. Be sure to export your databases and tables using
something like Navicat 8.0 first.

HOW TO CONNECT.
----------------------------------------------

0. Your invalid memory sequence rather sounds like your current session
system memory is messed up. REBOOT YOUR PC then try the following.

1. You probably do not need this since you have 5.0 already. But just in
case you could load MYSQL 5.0 found here (from Jeffry Horner). If you
have MYSQL 5.1 installed, the MYSQL 5.0 install will complain about
already having a mysql service running. So this means that MYSQL 5.1
needs to be removed before installing MYSQL 5.0 (save your databases
first).
http://dev.mysql.com/downloads/mysql/5.0.html

2. MY SQL 5.0 installation instructions. These are very helpful and
saved me lots of trouble.

2A. You might want to "REMOVE INSTANCE" of your current 5.0 settings in
the MYSQL Server Instance Configuration Wizard. Then establish a new one
with the instructions below. Note the mysql 5.0 setup wants a root
password. That is what it is requesting but it does not quit tell you.
So type in a simple password for root. Then when you connect its account
root and password simple.

2B. Set up MYSQL 5.0
http://www.iis-aid.com/articles/how_to_guides/install_and_configure_mysql_5_on_windows?page=0%2C0

R SQL call examples.
http://www.phaget4.org/R/R_notes.html

Hope this helps,
Jim Burke

Christophe Dutang wrote:

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

--
Christophe Dutang
Ph. D. student at ISFA, Lyon, France
website: http://dutangc.free.fr

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

Brian Ripley

Sun, Feb 22, 2009 10:44 PM #

On Sun, 22 Feb 2009, Jim Burke wrote:

I certainly does.  But the R Windows binary on CRAN was compiled 
agiant MySQL 5.0.x, and so you need to compile RySQ from the sources.

See the arhives of this lists, R-help ....

There is no such version. and you have been told so before. 
Presumably you mean 5.1.31.

libmySQL.dll: 1/23/2009 3:45am

My SOLUTION from Jeffrey Horner was to roll back to MYSQL 5.0 which worked
just fine. Be sure to export your databases and tables using something like
Navicat 8.0 first.

HOW TO CONNECT.
----------------------------------------------

0. Your invalid memory sequence rather sounds like your current session
system memory is messed up. REBOOT YOUR PC then try the following.

1. You probably do not need this since you have 5.0 already. But just in case
you could load MYSQL 5.0 found here (from Jeffry Horner). If you have MYSQL
5.1 installed, the MYSQL 5.0 install will complain about already having a
mysql service running. So this means that MYSQL 5.1 needs to be removed
before installing MYSQL 5.0 (save your databases first).
http://dev.mysql.com/downloads/mysql/5.0.html

2. MY SQL 5.0 installation instructions. These are very helpful and saved me
lots of trouble.

2A. You might want to "REMOVE INSTANCE" of your current 5.0 settings in the
MYSQL Server Instance Configuration Wizard. Then establish a new one with the
instructions below. Note the mysql 5.0 setup wants a root password. That is
what it is requesting but it does not quit tell you. So type in a simple
password for root. Then when you connect its account root and password
simple.

2B. Set up MYSQL 5.0
http://www.iis-aid.com/articles/how_to_guides/install_and_configure_mysql_5_on_windows?page=0%2C0

R SQL call examples.
http://www.phaget4.org/R/R_notes.html

Hope this helps,
Jim Burke

Christophe Dutang wrote:

I think there is problem of compatibility between the MySQL version  5.0 
and RMySQL. I think you should use MySQL 5.1. Take a look to 
https://stat.ethz.ch/pipermail/r-sig-db/2008q4/000520.html


Le 22 f?vr. 09 ? 12:57, Khalid Iqbal a ?crit :

R v 2.8.1
RMySQL v 0.7-3
MySQL v 5.0

On Sun, Feb 22, 2009 at 4:43 PM, Christophe Dutang  <dutangc at gmail.com> 
wrote:
Give us information about your configuration the R version, the  version 
of RMySQL, the version of MySQL...

Le 22 f?vr. 09 ? 12:08, Khalid Iqbal a ?crit :

hi,
i am new to R environment. I tried connecting to MySQL databases,  but it 
is
not getting connected. I am using Windows XP. I got this when i  tried to
incude RMySQL library.

library(RMySQL)
Loading required package: DBI
Error in inDL(x, as.logical(local), as.logical(now), ...) :
 unable to load shared library
'C:/PROGRA~1/R/R-28~1.1/library/RMySQL/libs/RMySQL.dll':
 LoadLibrary failure:  Invalid access to memory location.

Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'

Please help me.

Regards,
khalid

       [[alternative HTML version deleted]]

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

--
Christophe Dutang
Ph. D. student at ISFA, Lyon, France
website: http://dutangc.free.fr

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

Brian D. Ripley,                  ripley at stats.ox.ac.uk
Professor of Applied Statistics,  http://www.stats.ox.ac.uk/~ripley/
University of Oxford,             Tel:  +44 1865 272861 (self)
1 South Parks Road,                     +44 1865 272866 (PA)
Oxford OX1 3TG, UK                Fax:  +44 1865 272595

Jeffrey Horner

Mon, Feb 23, 2009 6:53 AM #

Prof Brian Ripley wrote:

In fact, I have provided a binary compiled against MySQL 5.1 on the 
RMySQL website:

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

Jeff

See the arhives of this lists, R-help ....

MY PC VERSIONS THAT **DID NOT WORK** ARE BELOW
----------------------------------------------

OPERATING SYSTEM INFORMATION
----------------------------
OS..........: Win XP sp3
R...........: 2.8.1
RMySQL.dll..: 0.7-3
MYSQL.......: 5.31  (problem, has new version of libmySQL.dll that 
does not work in R yet).

There is no such version. and you have been told so before. Presumably 
you mean 5.1.31.

libmySQL.dll: 1/23/2009 3:45am

My SOLUTION from Jeffrey Horner was to roll back to MYSQL 5.0 which
worked just fine. Be sure to export your databases and tables using
something like Navicat 8.0 first.

HOW TO CONNECT.
----------------------------------------------

0. Your invalid memory sequence rather sounds like your current
session system memory is messed up. REBOOT YOUR PC then try the
following.

1. You probably do not need this since you have 5.0 already. But just
in case you could load MYSQL 5.0 found here (from Jeffry Horner). If
you have MYSQL 5.1 installed, the MYSQL 5.0 install will complain
about already having a mysql service running. So this means that MYSQL
5.1 needs to be removed before installing MYSQL 5.0 (save your
databases first).
http://dev.mysql.com/downloads/mysql/5.0.html

2. MY SQL 5.0 installation instructions. These are very helpful and
saved me lots of trouble.

2A. You might want to "REMOVE INSTANCE" of your current 5.0 settings
in the MYSQL Server Instance Configuration Wizard. Then establish a
new one with the instructions below. Note the mysql 5.0 setup wants a
root password. That is what it is requesting but it does not quit tell
you. So type in a simple password for root. Then when you connect its
account root and password simple.

2B. Set up MYSQL 5.0
http://www.iis-aid.com/articles/how_to_guides/install_and_configure_mysql_5_on_windows?page=0%2C0

R SQL call examples.
http://www.phaget4.org/R/R_notes.html

Hope this helps,
Jim Burke

Christophe Dutang wrote:

I think there is problem of compatibility between the MySQL version  
5.0 and RMySQL. I think you should use MySQL 5.1. Take a look to 
https://stat.ethz.ch/pipermail/r-sig-db/2008q4/000520.html


Le 22 f?vr. 09 ? 12:57, Khalid Iqbal a ?crit :

R v 2.8.1
RMySQL v 0.7-3
MySQL v 5.0

On Sun, Feb 22, 2009 at 4:43 PM, Christophe Dutang  
<dutangc at gmail.com> wrote:
Give us information about your configuration the R version, the  
version of RMySQL, the version of MySQL...

Le 22 f?vr. 09 ? 12:08, Khalid Iqbal a ?crit :

hi,
i am new to R environment. I tried connecting to MySQL databases,  
but it is
not getting connected. I am using Windows XP. I got this when i  
tried to
incude RMySQL library.

library(RMySQL)
Loading required package: DBI
Error in inDL(x, as.logical(local), as.logical(now), ...) :
 unable to load shared library
'C:/PROGRA~1/R/R-28~1.1/library/RMySQL/libs/RMySQL.dll':
 LoadLibrary failure:  Invalid access to memory location.

Error : .onLoad failed in 'loadNamespace' for 'RMySQL'
Error: package/namespace load failed for 'RMySQL'

Please help me.

Regards,
khalid

       [[alternative HTML version deleted]]

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

-- 
Christophe Dutang
Ph. D. student at ISFA, Lyon, France
website: http://dutangc.free.fr

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

_______________________________________________
R-sig-DB mailing list -- R Special Interest Group
R-sig-DB at stat.math.ethz.ch
https://stat.ethz.ch/mailman/listinfo/r-sig-db

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