title: How to export 4 million data in MySQL?
body: <p>I have a database with one particular table having more than 4 million record entries. I tried downloading whole db it using MySQL workbench as well as command terminal using following command:</p>
  
  <pre><code>mysqldump -u root -p password mydb &gt; myfile.sql
  </code></pre>
  
  <p>But, I got only half of the data downloaded. If I ignored that one particular table, then it's working fine. Can anyone suggest me how to download db with tables having more than million entries?</p>