Title: Moving database error
Last modified: August 18, 2016

---

# Moving database error

 *  [raker](https://wordpress.org/support/users/raker/)
 * (@raker)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/moving-database-error/)
 * I’m moving my wordpress blog from one server to another, and I was following 
   the instructions on the WordPress codex, but I came across this error message.
   Does anybody have any idea what’s wrong?
 * 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—- eNqdkM9y2yAQxu88xR5ylDBCtqtwU23F8YxsK0JNe4uRRWPN6F8Bx/
   Gz5ZBHyisUNHVPOYUBZufb 3e/HkuT5LmewCGBBIU22DAKgEEZTxAurvyG0eOQMbtYVA/2nGYTSUuGmLvFwHLwXoDicAyVkNiGR
   3TZklLIggEa2t5C8DnCDNhf+kDKYYoLpzNdGdJVQFfrBc9hxD+JVsi08eEws72fdwTqBOSYo28TM 
   2s/x1B8airL7zJV4O+6cQmwRad2dXlEab1cMZOfXuvejaHbrB2jkfby9+z7YZ24ucdVaY6vC8tQO 
   yMovUum67/4DAicejRnYZHI+n9107UW4NtxJ45Lu3PfaMGj6g2iONnTSSnZSCeO8irqVDO5kCeSb 
   5z5lDsIACRkJIdu4Yi6VBV/hDEJMQzyLXGqc76qPA5IrdSmMKIW23nt5OPbnp6rcjzl3+V9c6Ope 
   iLKRoI06HcxJSfjdKzCjtn8WrdRPB2Hkc69qqf9Rl/kugyL+niawvoPk15oX/JPiv5/EpWE= —-END
   CUT—- —-BEGIN RAW—-
 * ERROR: C1 C2 LEN: 1 2 384
    STR: »
 * CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
    MySQL: 4.0.25-
   standard USR OS, AGENT, VER: Win IE 6.0 PMA: 2.6.4-pl2 PHP VER,OS: 4.3.11 Linux
   LANG: en-iso-8859-1 SQL: – phpMyAdmin SQL Dump — version 2.6.4-pl1 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net)——
   Host: localhost — Generation Time: Feb 07, 2006 at 03:03 PM — Server version:
   3.23.58 — PHP Version: 4.3.10 — — Database: `echow_db` —
 * — ——————————————————–
 * —
    — Table structure for table `games_categories` —
 * DROP TABLE IF EXISTS `games_categories`
    —-END RAW—- SQL query:
 * – phpMyAdmin SQL Dump — version 2.6.4-pl1 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net)——
   Host: localhost — Generation Time: Feb 07, 2006 at 03:03 PM — Server version:
   3.23.58 — PHP Version: 4.3.10 — — Database: `echow_db` — — ——————————————————–——
   Table structure for table `games_categories` — DROP TABLE IF EXISTS `games_categories`
   
   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 ‘– phpMyAdmin
   SQL Dump
    — version 2.6.4-pl1 — [http://www.ph](http://www.ph)

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

 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/moving-database-error/#post-333702)
 * 
 * That’s the problem.
    Open the .sql file in Notepad and look at the start. You’ll
   see those three characters. Delete them. Save the File. Redo the import and all
   should be good.
 *  Thread Starter [raker](https://wordpress.org/support/users/raker/)
 * (@raker)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/moving-database-error/#post-333925)
 * hmmm… I did a search for those three characters, and nothing came up in my .sql
   file.
 *  [Mark (podz)](https://wordpress.org/support/users/podz/)
 * (@podz)
 * [20 years, 3 months ago](https://wordpress.org/support/topic/moving-database-error/#post-333926)
 * It’s in 3 times – look in the code you pasted above.
 *  [sk4sk4](https://wordpress.org/support/users/sk4sk4/)
 * (@sk4sk4)
 * [20 years ago](https://wordpress.org/support/topic/moving-database-error/#post-334061)
 * i’m havin the same problem with the same  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—- eNqdkM+O2jAQxu9+ijnsMTZxQlDWtxRSFikhbJxuq14WA2bJKv/
   > qmA3pq+2hj9RXqI1KK/VYy7ZG 33ye34zjPM9yBnMKcw+SeM2Aggd+OEW8MPo7QvMnzuBudWDQf6s6oXqpSFXuSHfqnDfwiD8Dz3WD
   > iRuabULmeYxSqGR9D/GlgzuUjvwxYTAlLvEC3GvRHIQ64Kp9QZ94Dhl3IFrG68KBp9gwP5cNpNnX
   > VZJEEBAXbdKIGc6MTHFX+WjzsLE+J+O2pE+oi03nZXO+oCRaLxnIBpd9i8MwuMcUXdE/339gDKbj
   > dIwOtalvVFic6w4Z+U2qvmybPwjPiietOzaZDMNgB61HYZ+RRmqbtOeh7TWDqt2L6mRCKy1lI5XQ
   > tlZR1pJBKkZwfcf+zwyEBnfKaABRas1cKgO+we0olNDQZq4D/pXNhPQGXQgtdqI3pbfHy+n7cXh9
   > fa7HnfnJ7dViL/yfC90ghdhVEnqtznt9VhKOrQJ91bZD97wXWr60qpT9b+QizzZQRB+SGFYfIf6y
   > 4gX/1/kLQ2+pYQ== —-END CUT—- —-BEGIN RAW—-
   > ERROR: C1 C2 LEN: 1 2 384
   >  STR: »
   > CVS: $Id: sqlparser.lib.php,v 2.36 2005/08/08 20:22:11 lem9 Exp $
   >  MySQL: 4.0.25-
   > standard-log USR OS, AGENT, VER: Win MOZILLA 5.0 PMA: 2.6.4-pl3 PHP VER,OS:
   > 4.3.10-2 Linux LANG: en-iso-8859-1 SQL: – phpMyAdmin SQL Dump — version 
   > 2.6.4-pl2 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net) — — Host:
   > localhost — Generation Time: May 03, 2006 at 04:15 AM — Server version: 4.1.18—
   > PHP Version: 4.3.11 — — Database: `fxhzfwjj_myblog` —
   > — ——————————————————–
   > —
   >  — Table structure for table `wp_categories` —
   > DROP TABLE IF EXISTS `wp_categories`
   > —-END RAW—-
   > SQL query:
   > – phpMyAdmin SQL Dump — version 2.6.4-pl2 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net)——
   > Host: localhost — Generation Time: May 03, 2006 at 04:15 AM — Server version:
   > 4.1.18 — PHP Version: 4.3.11 — — Database: `fxhzfwjj_myblog` — — ——————————————————–——
   > Table structure for table `wp_categories` — DROP TABLE IF EXISTS `wp_categories`
   > 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 ‘– phpMyAdmin SQL Dump — version 2.6.4-pl2 — [http://www.ph](http://www.ph)
 * i did a search for the bad characters but none were to be found. anyone have 
   any suggestions?
 *  [sk4sk4](https://wordpress.org/support/users/sk4sk4/)
 * (@sk4sk4)
 * [20 years ago](https://wordpress.org/support/topic/moving-database-error/#post-334062)
 * when i look at the .sql file in notepad, the characters are not in the beginning
   of as it says they are in the error message. how can i get around this?

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

The topic ‘Moving database error’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [message](https://wordpress.org/support/topic-tag/message/)
 * [moving](https://wordpress.org/support/topic-tag/moving/)
 * [phpmyadmin](https://wordpress.org/support/topic-tag/phpmyadmin/)

 * In: [Installing WordPress](https://wordpress.org/support/forum/installation/)
 * 5 replies
 * 3 participants
 * Last reply from: [sk4sk4](https://wordpress.org/support/users/sk4sk4/)
 * Last activity: [20 years ago](https://wordpress.org/support/topic/moving-database-error/#post-334062)
 * Status: not resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics