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

[Janko Thyson]

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