title: #1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version
body: <p>I have an old database. Am uploading it into SQL using phpmyadmin But when I want to import it I get an error. It seems the first table even cannot get imported:</p>
  
  <pre><code>CREATE TABLE `manager` (
    `username` VARCHAR(20) NOT NULL, 
    `password` VARCHAR(50) NOT NULL,
    `email` VARCHAR(100) NOT NULL ,
    `deposit` VARCHAR( 50 ) DEFAULT '0' NOT NULL
  )
  TYPE = MYISAM
   CHARACTER SET utf8 COLLATE utf8_new_ci
  </code></pre>
  
  <blockquote>
    <p>MySQL said: Documentation</p>
    
    <p>#1064 - You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use
    near 'TYPE = MYISAM CHARACTER SET utf8 COLLATE utf8_new_ci' at line 7</p>
  </blockquote>
  
  <p>How can I resolve this issue?</p>