title: Restoring dump file after MySQL server migration from 5.1.51 to 5.5.10 throws error 1064
body: <p>On a Windows 7 machine running MySQL server 5.1.51 (both 64bit), before migrating to 5.5.10, I made a backup of my entire database using MySQL Administrator. After installing 5.5.10, I tried to restore the dump file but it throws one error:</p>
  
  <pre><code>ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'TYPE = MyISAM  DEFAULT CHARSET latin1 COLLATE latin1_german1_ci  ; SELECT co_n' at line 9"
  </code></pre>
  
  <p>I tried restore through several MySQL applications (Workbench, SQLYog) and the command line, but all throw the same error. It also throws several warnings that are however not displayed.</p>
  
  <p>Two questions:</p>
  
  <ol>
  <li><p>Of course, can you help me resolve this issue? Do I have to edit the sql dump file in some way? That's cumbersome though, since it's over 3GB. I thought I had followed all the steps with respect to upgrading mentioned in the MySQL documentation, so now I am a bit frustrated and scared of data loss.</p></li>
  <li><p>When restoring from the command line, how can I make <code>mysql.exe</code> log all warnings and errors to a text file?</p></li>
  </ol>