title: Configuring MySQL server to avoid "MySQL Server has gone away" error
body: <p>When I tried to establish a MySQL database using a dump, I got the following error message</p>
  
  <pre><code>ERROR 2006 (HY000) at line 312: MySQL server has gone away
  </code></pre>
  
  <p>After extensive Googling (and searching in this forum), I found that I have to increase the <code>max_allowed_packet</code> in the <code>my.ini</code> file. I have tried various values (including very large values) for this parameter, but I cannot get rid of this error.</p>
  
  <p>Even if I specify the --max_allowed-packet option in the command line (as follows) there is no use</p>
  
  <pre><code>C:\Users\Panora&gt;mysql --user=root --password=root --max-allowed-packet=600M db &lt; dump.sql
  ERROR 2006 (HY000) at line 50973: MySQL server has gone away
  </code></pre>
  
  <p>I tried creating the dump file using the following command, still no use</p>
  
  <pre><code>mysqldump --opt --skip-extended-insert --max_allowed_packet=10M --user=root --password=root db &gt; dump.sql
  </code></pre>
  
  <p>Please advice me what I am really missing.</p>