title: ERROR 2006 (HY000) line 9675: MySQL server has gone away
body: <p>I am trying to restore a database (size 477mb) and keep getting the error: <em>MySQL server has gone away</em>. I am not sure how to fix this error. I have tried:</p>
  
  <ul>
  <li>Changing the <code>max_allowed_packets</code> to 600M. </li>
  <li>Increasing the <code>wait_timeout</code> to 2880000. </li>
  </ul>
  
  <p>But none of these helped. This is the exact error message:</p>
  
  <blockquote>
    <p>18:13:52 Restoring C:\Users\Niting\Documents\Backup 20120918 0000.sql</p>
    
    <p>Running: mysql.exe --defaults-extra-file="c:\users\niting\appdata\local\temp\tmp_krvy8.cnf"
    --host=localhost --user=root --port=3306 --default-character-set=utf8 --comments &lt; "C:\Users\Niting\Documents\Backup 20120918 0000.sql"`</p>
    
    <p>ERROR 2006 (HY000) at line 9675: MySQL server has gone away</p>
  </blockquote>
  
  <p>Line 9675 Contains</p>
  
  <pre><code>(
  3434,'','','brocar',18730,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
  ,NULL,NULL,NULL,NULL,'false',NULL,NULL,'true',NULL,'Once',NULL,NULL,NULL
  ,NULL,NULL,'false',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'false'
  ,NULL,'false','false',NULL,'Accomplishment','false',NULL,NULL,NULL,NULL
  ,NULL,NULL,NULL,71,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL
  ,NULL,'2011-10-30','true',0,'false',NULL,NULL,NULL,NULL,NULL,NULL,'false'
  ,NULL,NULL,'2011-10-30',NULL,NULL,NULL,NULL,NULL,NULL,'2011-10-30','14:35:27'
  ),
  </code></pre>
  
  <p>That line is under this insert:</p>
  
  <pre><code>INSERT INTO `tbldelinspect` (
  `DELINSPECTID`,`DATE`,`TIME`,`USER`,`PIECEID`,`MARQUE`,`MODEL`,`SN`,`FROMTTAF`
  ,`FROMDATE`,`TBOHRS`,`INSTALLTTAF`,`INSTALLDATE`,`INSTALLCUSTOM`,`TBOMONTH`
  ,`HRSWARNING`,`MONTHWARNING`,`NOM`,`ISDUE`,`ACREG`,`DESCRIPTION`,`ISAD`
  ,`ADWHATSDONE`,`ADTYPE`,`NBSTART`,`CUSTOMCOMPUTEID`,`GROUPID`,`INVENTAIREID`
  ,`ATACODE`,`ADDONE`,`ADINTERVALTYPE`,`REMAINHRS`,`DUETTAF`,`DATENEXTINSPECT`
  ,`NOTE`,`CORRECTION`,`SHORTDESC`,`TTSO`,`REMAINMONTH`,`WARN`,`TSO`,`ISINSPECTION`
  ,`ISCURRENTINSPECTION`,`MONTHSATINSTALL`,`ACTION`,`UPDATE_`,`TSN`,`TTSN`,`MSN`
  ,`TMSN`,`REMAINCUSTOM`,`DUECUSTOM`,`TMSO`,`AIRCRAFTID`,`CUSTOMTBO`,`FROMCUSTOM`
  ,`CUSTOMWARNING`,`CUSTSN`,`TCUSTSN`,`CUSTOMATINSTALL`,`TCUSTSO`,`CUSTOMENGINE`
  ,`OLDMAXNG`,`MAXNG`,`ADCOMPONENT`,`LASTUPDATE`,`KEEPHISTORY`,`STARTADD`,`ISTASK`
  ,`TASKNO`,`RELATEDPIECEID`,`AIRCRAFTZONE`,`REFERENCE`,`PARTNO`,`TEMPLATEKEY`
  ,`ISSPECIALINSPECT`,`MANUALNEXTDUETTAF`,`MANUALNEXTDUECUSTOM`,`MANUALNEXTDUEDATE`
  ,`PERFAFTERXTTAF`,`PERFAFTERXMONTH`,`PERFAFTERXCYCLE`,`SPECIALTASKLINKPIECEID`
  ,`TOLERANCEVALUE`,`ASSEMBLYMASTERID`,`DELDATE`,`DELTIME`
  ) 
  VALUES
  </code></pre>
  
  <p>Any ideas how to get over this issue so I can restore my MySQL database? </p>