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!