Re: [R] RMySQL LoadLibrary failure: Invalid access to memory location.

From: Talbot Katz <>
Date: Fri, 19 Oct 2007 13:38:51 -0400


A colleague of mine figured out how to get the RMySQL 0.6 package to load properly in our environment with MySQL 5.0.45. Every time I tried to load the RMySQL library in R 2.5.1 I was getting an error message:   LoadLibrary failure: Invalid access to memory location.

We did the following:
First obtain RMySQL 0.5-7, which can be found at, but don't overwrite the RMySQL 0.6 folder with this, place it in a separate location. Then, from the RMySQL_0.5-7 libs sub-folder, grab the file libMySQL.dll. This is a MySQL dll that is not included in the RMySQL_0.6 libs sub-folder. Then copy this version of libMySQL.dll, dated January 28th, 2006, to the system folder, C:\WINDOWS\system32, overwriting the copy that was there (I didn't see which one it was, but the libMySQL.dll in the MySQL Server 5.0\bin sub-folder is dated July 6th, 2007). Now the RMySQL library loads correctly in R 2.5.1 on my Windows XP machine. I'm keeping my fingers crossed that we haven't violated some other universal edict... mailing list PLEASE do read the posting guide and provide commented, minimal, self-contained, reproducible code. Received on Fri 19 Oct 2007 - 17:42:12 GMT

Archive maintained by Robert King, hosted by the discipline of statistics at the University of Newcastle, Australia.
Archive generated by hypermail 2.2.0, at Fri 19 Oct 2007 - 18:36:40 GMT.

Mailing list information is available at Please read the posting guide before posting to the list.