[R-sig-DB] RMySQL and xampp: crash upon reading tables

[Janko Thyson]

Hi again,

I'm really sorry, but I was "one off" concerning the versions of xampp. The
one that includes MySQL 5.0.67 was version 1.6.8 and not 1.7.0.

It works fine now! 

One last question, though: It says at
http://biostat.mc.vanderbilt.edu/wiki/Main/RMySQL that RMySQL (0.7-4) should
also work with MySQL 5.1.33. I found that's not the case. Did I do something
wrong?

Best regards,
Janko Thyson

-----Ursprüngliche Nachricht-----
Von: Janko Thyson [mailto:janko.thyson using ku-eichstaett.de] 
Gesendet: Dienstag, 1. Dezember 2009 12:05
An: 'r-sig-db using stat.math.ethz.ch'
Cc: 'janko.thyson using kuei.de'
Betreff: RMySQL and xampp: crash upon reading tables

Hi everyone,

I am trying to get RMySQL to work with the MySQL version(s) that ship with
xampp.

What is strange is the fact that establishing a connection and writing
content to tables work just fine. However, R crashes when trying to read
tables from a database. I used MySQL-Server (5.0.67) prior to xampp and
everything worked fine.

The Xampp versions I tried: 
1.7.2 (MySQL 5.1.37), 1.7.1 (MySQL 5.1.33) and finally 1.7.0 (MySQL 5.0.67).
The last two xampp versions should definitely work, shouldn’t they? Yet I’ve
experienced the same behavior also with the newest version, just having
RMySQL throw an error (which it should). Xampp is located at "C:\xampp

Here’s some information that is probably relevant:

Code Snippets
#############

install.packages("RMySQL", repos=repos.cran,
	configure.args="--with-mysql-dir=C:/xampp/mysql/bin")

sessionInfo()
R version 2.9.2 (2009-08-24) 
i386-pc-mingw32 

locale:
LC_COLLATE=German_Germany.1252;LC_CTYPE=German_Germany.1252;LC_MONETARY=Germ
an_Germany.1252;LC_NUMERIC=C;LC_TIME=German_Germany.1252

attached base packages:
[1] stats     graphics  grDevices utils     datasets  methods   base     

.libPaths()
"C:/R/R-2.9.2/library"

Sys.getenv('MYSQL_HOME')
MYSQL_HOME 
        "" 
utils::readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
$`MySQL Server 5.0`
$`MySQL Server 5.0`$DataLocation
[1] "C:\\xampp\\mysql\\data\\"

$`MySQL Server 5.0`$FoundExistingDataDir
[1] "1"

$`MySQL Server 5.0`$Location
[1] "C:\\xampp\\mysql\\"

$`MySQL Server 5.0`$Version
[1] "5.0.67"

Additional comments
####################

I also tried this:
set MYSQL_HOME=C:\xampp\mysql

But still Sys.getenv(“MySQL_HOME”) gave me “”. What did I do wrong?

I think the registry entries were still there from the “old” MySQL-Server
5.0 installation and I simply adapted the values to the current xampp
configuration. If that was wrong, what do I do to get a “fresh and correct”
registry entry?

Best regards,
Janko Thyson