Connection with MySQL usin RMySQL package
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:
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
-- Christophe Dutang Ph. D. student at ISFA, Lyon, France website: http://dutangc.free.fr [[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