title: adding RMySQL package to R fails (on Windows)?
body: <p>I can't figure out why my RMySQL package won't install - here's what I get:</p>
  
  <pre><code>&gt; install.packages('RMySQL',type='source')
  trying URL 'http://cran.mirrors.hoobly.com/src/contrib/RMySQL_0.7-5.tar.gz'
  Content type 'application/x-gzip' length 160769 bytes (157 Kb)
  opened URL
  downloaded 157 Kb
  
  * installing *source* package 'RMySQL' ...
  ERROR: configuration failed for package 'RMySQL'
  * removing 'C:/PROGRA~1/R/R-212~1.0/library/RMySQL'
  
  The downloaded packages are in '(foo)'
  
  Warning message:
  In install.packages("RMySQL", type = "source") : installation of package 'RMySQL' had    non-zero exit status
  </code></pre>
  
  <p>I don't think it's a problem with the MySQL install, as the right values seem to be in the registry:</p>
  
  <pre><code>&gt; Sys.getenv('MYSQL_HOME')
                   MYSQL_HOME "C:/PROGRA~1/MySQL/MYSQLS~1.1/" 
  &gt; readRegistry("SOFTWARE\\MySQL AB", hive="HLM", maxdepth=2)
  $`MySQL Server 5.1`
  $`MySQL Server 5.1`$DataLocation
  [1] "C:\\Documents and Settings\\All Users\\Application Data\\MySQL\\MySQL Server 5.1\\"
  
  $`MySQL Server 5.1`$FoundExistingDataDir 
  [1] "0"
  
  $`MySQL Server 5.1`$Location 
  [1] "C:\\Program Files\\MySQL\\MySQL Server 5.1\\"
  
  $`MySQL Server 5.1`$Version
  [1] "5.1.54"
  </code></pre>
  
  <p>Puzzled.  Any help would be greatly appreciated!</p>