Title: Uploading MySQL Database Error
Last modified: August 18, 2016

---

# Uploading MySQL Database Error

 *  Resolved [thebloke](https://wordpress.org/support/users/thebloke/)
 * (@thebloke)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/uploading-mysql-database-error/)
 * I followed all the steps that is documented in this post: [http://wordpress.org/support/topic/40686](http://wordpress.org/support/topic/40686)
   including searching for and replacing the offending line (actually I found that
   when you export the file and choose MYSQL compatibility in the first place it
   doesn’t contain the offending line). However, when I import (whatever compatibility
   I choose) I get this error message and I am stumped. Can anyone help, please?
 * Error message follows:
 * Server: localhost – Database: intheout_wrdp1
    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—- eNqdkM1y2yAUhfc8xV1kKbBAceqwU2zV8YxkKUJNO9k02KaxpuinCMfxs2XRR
   +orBDTxdCbLMMAw 517OxyEpy7zkMKcwZ5Amaw4UGESzEInK6a8Ize8Fh4vVjsPwR/fSDMoQXW9Iv
   ++DZ2AkugIWhtNJ OHPTHTljnFLQqrmG5KWHC5SdxF3K4ZKEhE3xYGW7k2aHdfeEvokSchFAvEzWVQD3iWN
   +r1vI8odV msYwJSEqspg7zhW5xL1mqLgtfF+QC28ZEcdK6/bwgtJ4veSgWlwPHZ7NpteYohH87/UvxuDem53i
   XePcnQqLQ9MjJz8rM9RdOwIiB6Be3Fvb88nkeDz6mM1J+mukVdYX/brtBstBd1up9+7opaVqlZHW 
   e1V1ozjkWwssCsbfAWmBMh59gSLzzUIZBz7DfRBKaOQrY7z/ss93hi6klRs5OOvHY//T7tVGd7/V 
   41j2G/7kQGdAJTdawWDNYWsPRsGvzoAdNQ/cSqueOlOr4R25KPMCqvgmTWD1FZIfK1GJj51vK/in 
   Qw== —-END CUT—- —-BEGIN RAW—-
 * ERROR: C1 C2 LEN: 1 2 380
    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-pl2 PHP VER,OS: 4.3.11
   Linux LANG: en-iso-8859-1 SQL: – phpMyAdmin SQL Dump — version 2.6.3-pl1—
   [http://www.phpmyadmin.net](http://www.phpmyadmin.net) — — Host: localhost — 
   Generation Time: Oct 23, 2005 at 12:37 PM — Server version: 4.1.13 — PHP Version:
   4.3.11 — — Database: `wp_thebloke` —
 * — ——————————————————–
 * —
    — Table structure for table `wp_categories` —
 * DROP TABLE IF EXISTS `wp_categories`
 * —-END RAW—-
 * SQL query:
 * – phpMyAdmin SQL Dump — version 2.6.3-pl1 — [http://www.phpmyadmin.net](http://www.phpmyadmin.net)——
   Host: localhost — Generation Time: Oct 23, 2005 at 12:37 PM — Server version:
   4.1.13 — PHP Version: 4.3.11 — — Database: `wp_thebloke` — — ——————————————————–——
   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.3-pl1 — [http://www.ph](http://www.ph)[
   Back ]

Viewing 1 replies (of 1 total)

 *  Thread Starter [thebloke](https://wordpress.org/support/users/thebloke/)
 * (@thebloke)
 * [20 years, 7 months ago](https://wordpress.org/support/topic/uploading-mysql-database-error/#post-274987)
 * OK, I managed to successfully import.
 * First, this is my situation:
    I exported from the following system: phpMyAdmin
   2.6.3-pl1/MySQL 4.1.13 and trying to import to the following system: phpMyAdmin
   2.6.4-pl2/MySQL 4.0.25.
 * When I exported, I followed the instructions as per the page above but I chose
   MYSQL40 Compatibility. Instead of saving to a file, I chose open with SQLScriptFile(
   Default). When the resulting file opens up in Notepad, I copied the file to WordPad(
   to ensure the linebreaks are there, so I can visually scan the file to ensure
   it is “all there”). Then I copied that file to the SQL Query text region, and
   hit GO.
 * After a few minutes, the successful import message beamed at me from the screen.
   I checked the resulting tables, and they all seem to be there, intact!
 * Now, to finish the migration! 🙂

Viewing 1 replies (of 1 total)

The topic ‘Uploading MySQL Database Error’ is closed to new replies.

## Tags

 * [database](https://wordpress.org/support/topic-tag/database/)
 * [Import](https://wordpress.org/support/topic-tag/import/)
 * [MySQL](https://wordpress.org/support/topic-tag/mysql/)

 * In: [Fixing WordPress](https://wordpress.org/support/forum/how-to-and-troubleshooting/)
 * 1 reply
 * 1 participant
 * Last reply from: [thebloke](https://wordpress.org/support/users/thebloke/)
 * Last activity: [20 years, 7 months ago](https://wordpress.org/support/topic/uploading-mysql-database-error/#post-274987)
 * Status: resolved

## Topics

### Topics with no replies

### Non-support topics

### Resolved topics

### Unresolved topics

### All topics