title: Error while importing .sql through command line
body: <blockquote>
    <p><strong>Possible Duplicate:</strong><br>
    <a href="https://stackoverflow.com/questions/93128/mysql-error-1153-got-a-packet-bigger-than-max-allowed-packet-bytes">MySQL Error 1153 - Got a packet bigger than ‘max_allowed_packet’ bytes</a>  </p>
  </blockquote>
  
  
  
  <p>I have the .sql file which size is 26.3 MB and containing large data.</p>
  
  <p>I am trying to import it via command line by using this command :</p>
  
  <pre><code>mysql -uroot -p dbname &lt; /path/to/file.sql
  </code></pre>
  
  <p>But it's showing following error while importing</p>
  
  <pre><code>ERROR 1153 (08S01) at line 1: Got a packet bigger than 'max_allowed_packet' bytes
  </code></pre>
  
  <p>Is it the problem of size or if not then what is the problem?</p>
  
  <p>Thanks</p>