MySQL Forums
Forum List  »  MySQL Workbench

#1064 - You have an error in your SQL syntax
Posted by: jin zheng
Date: January 11, 2013 01:21PM

Deal All,

today, I when I tried to import my backup mysql database into my new database (two databases on different servers) through phpAdmin the following error appeared, honestely I am really a newbie in this domain and I really have no idea what I should do to get rid of this problem, could anyone help me with this? thanks in advance!

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----
eNrdk11PgzAUhrm1v+J4pwsfLZROMSYjjLglbExATbwhwNCRMZh8uO3fW1g0XhgTvfDCJ23O6Tlv
m6Z5a3ue6xlgEbBUcOy5AToDfQjDIUZ+wDsCQrODf+vwhkxkxqQkz9Gd74Hri2De2PNAhHubCx+y
Ambu49RxTC7FaDEzDdBkXdbQYrLoNKLrd6eoMgMnK9o9csz5jQFpgfrz4yhZt1uqJNtjpuzSdJ0f
lDhv02SVFcrmUL/kH8twVy1VmVeEH4A5jOI+crqoMa2PKmY6pVQXiIqHhDKs6kTAqqZSTQAs/AFt
3UQVgFCVZfOd7v0FhP+FJEHvNFi2my0QLBMNYJzVTZXF3DbcOJciPJXV0Txwtr9gIaPnSJL4gElZ
NwbkZRLlK54CZxw1URzVKbfWZ890aulXdDv9tHpNK+Czzsri5HgvKS+fEVIGpxQTTMC3Axi5zji0
JqZnWoHthbwUWs6Uf5fr0eirMgyUqzfstYvc
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 56 57 770
STR:

MySQL: 5.1.66-cll
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 3.5.3
PHP VER,OS: 5.2.6 Linux
LANG: en
SQL: backup4/cpbackup/weekly/bluechin/mysql/bluechin_wrd2.sql0000640000000000036300002065444512071460251023243 0ustar rootbluechin-- MySQL dump 10.13 Distrib 5.5.29, for Linux (x86_64)
--
-- Host: localhost Database: bluechin_wrd2
-- ------------------------------------------------------
-- Server version 5.5.29-log

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;


----END RAW----

SQL query:

backup4/cpbackup/weekly/bluechin/mysql/bluechin_wrd2.sql0000640000000000036300002065444512071460251023243 0ustar rootbluechin-- MySQL dump 10.13 Distrib 5.5.29, for Linux (x86_64) -- -- Host: localhost Database: bluechin_wrd2 -- ------------------------------------------------------ -- Server version 5.5.29-log /*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;

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 'backup4/cpbackup/weekly/bluechin/mysql/bluechin_wrd2.sql' at line 1

Options: ReplyQuote


Subject
Views
Written By
Posted
#1064 - You have an error in your SQL syntax
8874
January 11, 2013 01:21PM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.