SCENARIO: You are trying to import an SQL file into your database but receive the following error message:
“#1064 – 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 AUTO_INCREMENT=1’ at line“
HERE’S THE SOLUTION:
- Open the SQL file and look through its content
- Change TYPE = MYISAM into ENGINE = MYISAM. (* Important: Always make a backup of any file before making any changes, so you can have the original file to revert to if something goes wrong)
- Save the file to keep your changes
This should fix your problem!