title: R bulk upload data to MYSQL database
body: <p>there is the package: RMySQL</p>
  
  <p>How can I bulk upload lots of data to mysql from R? I have a csv with around 1 million lines and 80 columns.</p>
  
  <p>Would something like this work?</p>
  
  <pre><code>dbWriteTable(con, "test2", "~/data/test2.csv") ## table from a file
  </code></pre>
  
  <p>I fear this inserts line by line...</p>