SOLVED: MySQL Error #1064 in Syntax

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!



Bryan - After5PC

Husband. Father. Entrepreneur. Techie. Mental Health Nurse. Music. Speaker. Isaiah 60:1

I have been providing a range of services for clients with their personal or small business needs on the internet for over 14 years. Contact me if you need anything. You can certainly rely on me wherever you are located in the world. If you have access to the web, I can help you anywhere!

request my service

After5PC.net Digital Marketing Agency Porter Kingwood Humble The Woodlands Conroe Spring Cleveland Texas
Bryan - After5PC

Honestly... I just don't want my website to be like everyone else's!

I know it looks simple and ugly to some, but I don't want the design to look like a major business corporation. It is not. You are dealing with only one person with a big heart! A heart that established this small business through thick and thin... a heart that has endured for the last 14 years. You simply get... me! I will work hard on your project, just like I worked hard to keep this business going. Give me a chance. You won't regret it!

contact me

After5PC.net Digital Marketing Agency Houston Sugar Land Missouri City Pearland Richmond Rosenberg Baytown Crosby Texas
Bryan - After5PC

Connect with me via my business social media pages:

Follow Me on Social Media

After5PC.net New Caney Splendora Atascocita Tomball Montgomery Katy Texas
Legal Notices | Terms and Conditions
© Copyright 2019 - Duplication of content and images on this site without prior authorization is prohibited