title: Export a large MySQL table as multiple smaller files
body: <p>I have a very large MySQL table on my local dev server: over 8 million rows of data. I loaded the table successfully using LOAD DATA INFILE.</p>
  
  <p>I now wish to export this data and import it onto a remote host.</p>
  
  <p>I tried LOAD DATA LOCAL INFILE to the remote host. However, after around 15 minutes the connection to the remote host fails. I think that the only solution is for me to export the data into a number of smaller files.</p>
  
  <p>The tools at my disposal are PhpMyAdmin, HeidiSQL and MySQL Workbench.</p>
  
  <p>I know how to export as a single file, but not multiple files. How can I do this?</p>