This error is (MySQL said:) #1064 – You have an error in your SQL syntax; check

  • Dear boosters PLEASE HELP ME I’m working to move my WP site Goddady to HostGator BUT I’ve been problems into moving the database . How can I solve this problem ?
    This error is (MySQL said:)
    #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 ‘<!DOCTYPE html PUBLIC “-//W3C//DTD XHTML 1.0 Transitional//EN”
    “https://www.w&#8217; at line 1

Viewing 11 replies - 1 through 11 (of 11 total)

  • Where are you getting this error?

    Thread Starter Redoy

    (@redoy)

    When i am importing this database showing this error.

    That error tells me that your databases SQL export did not work corrctly.

    See the first line of the document that’s causing the error?

    <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN"

    That’s not SQL, that’s HTML. That means that whatever was used to export the database created an error, and what was saved was a HTML error page, not the database dump.

    You’ll need to get another exported copy of the database, and when you do check it to make sure that it’s not HTML code.

    Thread Starter Redoy

    (@redoy)

    I’ve exported this copy again and again but every time when i’ve importing showing this error. Please give me suggestions How can i solve this problem.

    Hi,

    Export your database again with gzip compression. Once i faced this problem and resolved by using gzip. So try it.

    Open the file in your browser, and see what it says. It should give you an error message that you can work with.

    If you can’t get this sorted out yourself then you need to contact your hosting company and ask them for support.

    Thread Starter Redoy

    (@redoy)

    Bro i’ve contact with my old hosting company(GODADDY) they answered me
    “if you are exporting it with phpmyadmin and this is giving you the database file and this is not allowing you to import this into host gator you would need to talk to host gator to see what may be causing the issue. “

    Also i don’t see gzip compression option on my admin panel i’ve seems that only Compression: None “zipped” “bzipped” so i’ve choice zipped options.

    Did you look at what the file that you’re downloading actually is? Open that file in yoru browser and read the error message. Then you’ll know what you actually need to tell them is wrong. GoDaddy support is well-knwon for not wanting to help much, so you really need to be able to tell them exactly what the error actually is so they can see it for themselves. You should send them the file as well and tell them that’s what you’ve got from the output – and also be very sure to tell them that it’s given you a HTML file, not a SQL file.

    Open the file in a text editor and delete the html lines at the top.

    Thread Starter Redoy

    (@redoy)

    i’ve check out on your process @radices but yet not solve my database importing problem. still showing error.

    Thanks catacaustic for your kind information . i’ve told our existing hosting support they told me discuss with new hosting provider it’s there problem not our. so i’ve discuss with new hosting provider they told me . talk with our web migration team .

    thanks all for your kind help

    Take care all

    Did you ever look at what the HTML part of the file said?

    With that information you could tell both places whas was wrong, but now you’re running a very high chance that the new company won’t be able to import anything because the file that you’re going ot give them is not valid SQL… becuase (as I’ve said all along) it’s a HTMl error message notification and I’d be 99.99% sure that there’s no SQL in that file at all.

    Which is why you need to know what the error is. Without knowing the actual error you cannot go back to your current hosting company and get them to fix the error on their server. Remember, until you can successfully export the data from your existing database, you cannot import it into a new database. Unless you get your old hosting service sorted out, your new hosting service will never work.

    I’m sorry if this sounds a bit harsh, but it does need to be said.

Viewing 11 replies - 1 through 11 (of 11 total)
  • The topic ‘This error is (MySQL said:) #1064 – You have an error in your SQL syntax; check’ is closed to new replies.