moving website

Permalink September 26, 2013 at 5:40 AM

Hi, i'm in the process of moving a website to a new host. Right now i'm importing the old database (the sql file) to the new database.

All tables seems to be imported correct but the import ends with the message:

There is a chance that you may have found a bug in the SQL     parser. Please examine your query closely, and check that the quotes are correct and not mis-matched. Other possible failure causes may be that you are uploading a file with binary outside of a quoted text area. 
(/....)
MySQL said: Documentation
#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 '' at line 1

Website looks to be working as usual. Should I be worried about this message?

JohntheFish replied on Sep 26, 2013 at 7:51 am Permalink Best Answer Reply

Have a look at the sql import file and see if it has blank lines at the end.

Post Reply

Delete Post

You are allowed to delete your post for 5 minutes after it's posted.

Delete

Mark Post as Spam

Are you sure you would like to mark this post as spam?

Mark as Spam

Destroy Spammer

This script will report this post as spam and add a permanent IP ban for this user, type "DESTROY" below to continue.

DESTROY SPAMMER

Sign In?

You must have a user account and be signed to perform this action.

This website stores cookies on your computer. These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media. To find out more about the cookies we use, see our Privacy Policy.

Forums

Developing (v7+)