title: dumping a MySQL table in chunks
body: <p>I would like to backup one big innodb MySQL table, but unfortunately don't have enough free space to create a full dump of it. So I thought about dividing the backup to two parts. Meaning I will dump half of the table, move that file to an external backup location, and than backup the second half and move it also. </p>
  
  <p>I'm used to doing: <code>mysqldump --user=$user --password=$pass --single-transaction --quick</code> </p>
  
  <p>How can I perform such an operation one half at a time?</p>