title: backing up big database on shared hosting. tried mysqldump and phpmyadmin
body: <p>So i am on godaddy shared hosting. need to backup db and data of some 20 tables with 500mb data.</p>
  
  <p><strong>solution tried :</strong></p>
  
  <p><strong>1. solution : phpmyadmin</strong> </p>
  
  <p>tried simply exporting the table and it starts exporting but fails in between because of error </p>
  
  <pre><code>mysql server has gone away
  </code></pre>
  
  <p>So tried to solve this problem by increasing wait_timeout but failed in it as well because i am on shared hosting it does not permit me. gives me error something like this</p>
  
  <pre><code>#1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  </code></pre>
  
  <p><strong>2. Solution tried : mysqldump</strong> </p>
  
  <p>Ran following command to backup a table with 110000 rows </p>
  
  <pre><code>mysqldump --user xxxxx --password=XXXXXXXXX Username wp_pc_products &gt;&gt; wp_pc_product.sql
  </code></pre>
  
  <p>This resulted in a file size of 55M And contains only 124 rows. </p>
  
  <pre><code>55M wp_pc_product.sql
  </code></pre>
  
  <p>Actual problem :</p>
  
  <p>Trying to migrate my database from shared hosting to VPS. </p>