adding RMySQL package to R fails (on Windows)?

by

The basic process is described here, but there are several hints, So I will describe the whole solution (please change the R version and paths if needed):

  1. Install latest RTools from here
  2. install MySQL or header and library files of mysql
  3. create or edit file C:\Program Files\R\R-2.12.1\etc\Renviron.site and add line like MYSQL_HOME=C:/mysql (path to your mysql files)
  4. copy libmysql.lib from mysql/lib to mysql/lib/opt to meet dependencies.
  5. copy libmysql.dll to C:\Program Files\R\R-2.12.1\bin or to windows/system32 directory.
  6. run install.packages('RMySQL',type="source") and wait while compilation will end.

This worked for me on Windows 7 64 bit, so there should be no problems with 32 bit versions

Initialy posted here (similar question).

More Related Contents:

  1. RMySQL dbWriteTable with field.types
  2. Fetching UTF-8 text from MySQL in R returns “????”
  3. Using LIMIT within GROUP BY to get N results per group?
  4. How can I output MySQL query results in CSV format?
  5. Change limit for “Mysql Row size too large”
  6. Converting a date in MySQL from string field
  7. Quick easy way to migrate SQLite3 to MySQL? [closed]
  8. Ordering by specific field value first
  9. CHECK constraint in MySQL is not working
  10. How to change the CHARACTER SET (and COLLATION) throughout a database?
  11. Equivalent of Oracle’s RowID in MySQL
  12. How can I get around MySQL Errcode 13 with SELECT INTO OUTFILE?
  13. Error Code 1292 – Truncated incorrect DOUBLE value – Mysql
  14. Getting all parent rows in one SQL query
  15. How can I manipulate MySQL fulltext search relevance to make one field more ‘valuable’ than another?
  16. Creating functions in phpMyAdmin – Error: access denied you need the super privilege for this operation
  17. storing money amounts in mysql
  18. MySQL CREATE FUNCTION Syntax
  19. Difference between two table structure
  20. How to retrieve JSON data from MySQL?
  21. R – when trying to install package: InternetOpenUrl failed
  22. MySQL equivalent of Oracle’s SEQUENCE.NEXTVAL
  23. Is incrementing a field in MySQL atomic?
  24. Delete from one table with join
  25. How to store decimal in MySQL?
  26. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  27. When to use a left outer join?
  28. MySQL: Compare BETWEEN time
  29. MySQL: how to do row-level security (like Oracle’s Virtual Private Database)?
  30. Count duplicates records in Mysql table?

Leave a Comment