MySQL Error Migrating WordPress

I just exported my Wordpress Database from an old server and imported it to a new server. The process I used was the usual PHPMyAdmin process that I do regularly so no issue there...

I got this error message and not sure what it means. Some of my website appears broken now on the new server and I feel this has something to do with it..

 Error
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. You can also try your query on the MySQL command line interface. The MySQL server error output below, if there is any, may also help you in diagnosing the problem. If you still have problems or if the parser fails where the command line interface succeeds, please reduce your SQL query input to the single query that causes problems, and submit a bug report with the data chunk in the CUT section below:
----BEGIN CUT----
eNo1jL0KwyAYRQvZvqe4DyBSNSHgJiLJ4F817V5Chy7ZCs3bxxR6p8PlcFwpqWhYASvhXdQQkBCC
6tLujijs9eY1Bj5wpeheC1JlMJOLC8PDNSk8V9i5pOCadeWqpxyMRt94pDzn02Kpng3JxQj/3j5f
8iZOGq+NfnnqLv8djMMfvA==
----END CUT----
----BEGIN RAW----
ERROR: C1 C2 LEN: 1 2 11
STR: 

MySQL: 5.5.33
USR OS, AGENT, VER: Mac CHROME 5.0.34
PMA: 4.0.7
PHP VER,OS: 5.2.17 Linux
LANG: en
SQL: 

----END RAW----

SQL query:



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 
[ Back ]

Solutions

Open your exported file into any editor and check if is there any special character or any line breakers are there? sometimes special characters stops the import process. In more i would suggest to check phpmyadmin version and mysql version.Or you can directly copy and past to sql tab in phpmyadmin see if it gives any error or not.

Not sure if you have shell access, but I use mysqldump it will avoid encoding issues.

https://dev.mysql.com/doc/refman/5.1/en/mysqldump.html

Tags: PHP / Mysql / Database

Similar questions

Error when migrating wordpress site from subfolder to root folder
This is what I'm seeing in the browser, after going through the steps at http://wp.smashingmagazine.com/2013/04/08/moving-wordpress-website/ Warning: Unexpected character in input: ''' (ASCII=39) state=1 in /home4/brycepj/public_html/index.php on line 17 Parse error: syntax error, unexpected '.' in /home4/brycepj/public_html/index.php on line 17 He...
An AJAX HTTP error Code: 200 while migrating from wordpress to drupal
I am getting this error while migrating my site from how to resolve this ?? I have tried updating the drupal_set_time_limit() to some bigger value(1800) in /includes/locale.inc but it didn't help. Thanks in advance
500 Error when Migrating Wordpress to Google Cloud
Yesterday I spent my Sunday (almost) migrating my Wordpress install to Google Cloud following their wordpress setup tutorial. I've not come to the point that I need help, I've got caught up by 500 errors when test submitting the subscribe form: http://v-sons.appspot.com/wtf/#subscribe Being new to GCE I don't really know how it works, but I managed...
Migrating WordPress 404 Error
I am migrating my site to a new server with a new domain. The front page loads fine, but any other link causes a 404 error. What could cause this??? A permalink issue?? This is what I have done: What else could it be? I even tried using Search-Replace-DB-master to search and replace in case of any serialized data and no avail. I can't even get to /...
Migrating Wordpress database to server SQL error
I have just finished a Wordpress site and I'm trying to set it up on the server. I did the following, as always: Of course, 'something' and 'else' are not the real values... Can anyone tell me if I did something wrong, or I didn't do something else at all? I never had this problem before? The differences are that the Wordpress itself got updated in...
Migrating WordPress from Local to Live Error
So I've migrated my wordpress from local to live and I've had a few issues with internal service error - which I mostly was able to solve. However, for some reason all my content is fully visible on the live site but when I go to the backend to edit - all of my pages are completely empty! Also, all of my images won't come up and strange black diamo...

Also ask

We use cookies to deliver the best possible experience on our website. By continuing to use this site, accepting or closing this box, you consent to our use of cookies. To learn more, visit our privacy policy.