title: ssh Mysql dump table parts (11GB DB to smaller pieces)
body: <p>I'm facing the following:</p>
  
  <p>We have a DB table of 11GB with over 257 million records and need a backup. Exporting via PHPmyAdmin isn't possible (chrome keeps crashing) and backing up with SSH mysqldump tablename will give a insufficient space disk error (error 28). </p>
  
  <p>Now I'd like to know if there is a way to export a mysqldump with a row 0 till ~100.000.000 command so we can make 3 parts (or smaller parts if required). </p>
  
  <p>What I'm using:</p>
  
  <blockquote>
    <p>mysqldump -p -u username database_name database_table > dbname.sql</p>
  </blockquote>
  
  <p>[EDIT]</p>
  
  <p>Found out how to get a row of &lt;50.0000.0000 to SQL with the following:</p>
  
  <blockquote>
    <p>mysqldump -p -u db_name db_table --where='id&lt;50000000'</p>
  </blockquote>
  
  <p>But the big question remains now, how to go further? Now I want to get all records between 50.000.000 and 100.000.000 .. </p>
  
  <p>Anybody knows the answer if it's possible and what command I should use?</p>