Firestone Technical Resources

"Personal service for your impersonal technology."

Brian Wright

President and CEO of Firestone Technical Resources, Inc. and primary blog contributor for technical solutions to computer problems.

His posts typically reflect real situations that required real solutions. Many of these solutions are compiled from several other blogs or just personal experience and put into a easy to follow process.
1 minute reading time (280 words)

MySQL Import of SQL file fails with error 1064

On a number of occasions I have attempted to import an exported MySQL database file and received the following message.

/* SQL Error (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 '?# -------------------------------------------------------- # Host:     ' at line 1 */
/* Error with snippets directory: The specified path was not found */

# --------------------------------------------------------
# Host:                         127.0.0.1
# Server version:               5.5.40 - MySQL Community Server (GPL)
# Server OS:                    Win32
# HeidiSQL version:             7.0.0.4053
# Date/time:                    2014-01-20 09:48:36
# --------------------------------------------------------

You would think after completing this many times I would remember what to do. But inevitably I forget one critical step and have to search all over the web for the solution. I'm sure I am not alone with this issue so I am posting this for my quick reference but also for anyone else that has the same issue.

If you have exported the database and then want to import it back into the existing database or into another one, there is a good chance that this error is incorrect and that there is nothing wrong with the file. So, the key to running this import is that you must select the file type as UTF-8 when you open the file. I found that with both, MyPHPAdmin and HeidiSQL, setting this option resolves the file import issue.

We hope that this information is helpful. Please let us know how this has helped you or if you have additional questions. As always Firestone Technical Resources, Inc. is here to help with your computer support issues - "Providing personal service for your impersonal technology."

0
Dell HDMI Video has no audio
Kaspersky Security Center Network Agent - Error 25...

Related Posts

 

Comments

Already Registered? Login Here
No comments made yet. Be the first to submit a comment

By accepting you will be accessing a service provided by a third-party external to http://firestonetechresources.com/