title: How to install RMySQL package for Windows?
body: <p>Since binary file of RMySQL package is not available, I am not able to install it on Windows.</p>
  
  <p>I looked up internet. I found this link. <a href="http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/comment-page-1/#comment-3123" rel="nofollow">http://www.ahschulz.de/2013/07/23/installing-rmysql-under-windows/comment-page-1/#comment-3123</a></p>
  
  <p>I followed the instructions, but I am getting an ERROR.</p>
  
  <p>This is the final output I get after</p>
  
  <pre><code>&gt;install.packages('RMySQL',type='source')
  </code></pre>
  
  <p>Installing package into ‘C:/Users/admin/Documents/R/win-library/3.0’
  (as ‘lib’ is unspecified)
  also installing the dependency ‘DBI’</p>
  
  <p>trying URL '<a href="http://cran.rstudio.com/src/contrib/DBI_0.2-7.tar.gz" rel="nofollow">http://cran.rstudio.com/src/contrib/DBI_0.2-7.tar.gz</a>'
  Content type 'application/x-gzip' length 194699 bytes (190 Kb)
  opened URL
  downloaded 190 Kb</p>
  
  <p>trying URL '<a href="http://cran.rstudio.com/src/contrib/RMySQL_0.9-3.tar.gz" rel="nofollow">http://cran.rstudio.com/src/contrib/RMySQL_0.9-3.tar.gz</a>'
  Content type 'application/x-gzip' length 165363 bytes (161 Kb)
  opened URL
  downloaded 161 Kb</p>
  
  <p>installing <em>source</em> package 'DBI' ...
  package 'DBI' successfully unpacked and MD5 sums checked
  R
  inst
  preparing package for lazy loading
  Creating a generic function for 'summary' from package 'base' in package 'DBI'
  help
  installing help indices
  building package indices
  installing vignettes
  testing if installed package can be loaded
  arch - i386
  arch - x64
  DONE (DBI)</p>
  
  <p>installing <em>source</em> package 'RMySQL' ...
  ** package 'RMySQL' successfully unpacked and MD5 sums checked
  checking for $MYSQL_HOME... C:\Program Files\MySQL\MySQL Server 5.6\
  cygwin warning:
    MS-DOS style path detected: C:\Program
    Preferred POSIX equivalent is: /cygdrive/c/Program</p>
  
  <p>CYGWIN environment variable option "nodosfilewarning" turns off this warning.
    Consult the user's guide for more details about POSIX paths:
      <a href="http://cygwin.com/cygwin-ug-net/using.html#using-pathnames" rel="nofollow">http://cygwin.com/cygwin-ug-net/using.html#using-pathnames</a>
  test: Files\MySQL\MySQL: unknown operand</p>
  
  <p>** libs
  Warning: this package has a non-empty 'configure.win' file,
  so building only the main architecture</p>
  
  <p>cygwin warning:
    MS-DOS style path detected: C:/PROGRA~1/R/R-30~1.1/etc/x64/Makeconf
    Preferred POSIX equivalent is: /cygdrive/c/PROGRA~1/R/R-30~1.1/etc/x64/Makeconf
    CYGWIN environment variable option "nodosfilewarning" turns off this warning.
    Consult the user's guide for more details about POSIX paths:
      <a href="http://cygwin.com/cygwin-ug-net/using.html#using-pathnames" rel="nofollow">http://cygwin.com/cygwin-ug-net/using.html#using-pathnames</a></p>
  
  <p>gcc -m64 -I"C:/PROGRA~1/R/R-30~1.1/include" -DNDEBUG -I"C:\Program Files\MySQL\MySQL Server 5.6\"/include    -I"d:/RCompile/CRANpkg/extralibs64/local/include"     -O2 -Wall  -std=gnu99 -mtune=core2 -c RS-DBI.c -o RS-DBI.o</p>
  
  <p>*<strong>*Syntax error: Unterminated quoted string
  make: <em></strong> [RS-DBI.o] Error 2
  ERROR: compilation failed for package 'RMySQL'</em>***</p>
  
  <ul>
  <li>removing 'C:/Users/admin/Documents/R/win-library/3.0/RMySQL'
  Warning in install.packages :
  running command '"C:/PROGRA~1/R/R-30~1.1/bin/x64/R" CMD INSTALL -l "C:\Users\admin\Documents\R\win-library\3.0" C:\Users\admin\AppData\Local\Temp\RtmpMvp14B/downloaded_packages/RMySQL_0.9-3.tar.gz' had status 1
  Warning in install.packages :
  installation of package ‘RMySQL’ had non-zero exit status</li>
  </ul>
  
  <p>The downloaded source packages are in
      ‘C:\Users\admin\AppData\Local\Temp\RtmpMvp14B\downloaded_packages’ </p>
  
  <p><em>I have written the error i am getting in bold. Please help me resolve it.
  Thanks a lot.</em></p>