title: MySql ERROR 1064 -restoring database
body: <p>HELP. I am not sure how to fix this error. I am trying to restore a MySql database that was given to me. But I get the following error message. </p>
  
  <p>ERROR 1064 (42000) at line 29: 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' at line 6</p>
  
  <pre><code>`-- MySQL Administrator dump 1.4
  --
  -- ------------------------------------------------------
  -- Server version   4.0.27-nt
  
  
  /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
  /*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
  /*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
  /*!40101 SET NAMES utf8 */;
  
  /*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
  /*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
  /*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
  
  
  --
  -- Create schema aircraftmanager
  --
  
  CREATE DATABASE IF NOT EXISTS aircraftmanager;
  USE aircraftmanager;
  
  --
  -- Definition of table `addump`
  --
  
  DROP TABLE IF EXISTS `addump`;
  CREATE TABLE `addump` (
    `ADID` int(11) NOT NULL auto_increment,
    `ADNO` varchar(175) default NULL,
    `AIRCRAFTID` int(11) default NULL,
    PRIMARY KEY  (`ADID`)
  ) TYPE=MyISAM;
  `
  </code></pre>