LinuxQuestions.org
Visit Jeremy's Blog.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Software
User Name
Password
Linux - Software This forum is for Software issues.
Having a problem installing a new program? Want to know which application is best for the job? Post your question in this forum.

Notices


Reply
  Search this Thread
Old 05-28-2004, 11:43 AM   #1
strez4prez
LQ Newbie
 
Registered: May 2004
Posts: 1

Rep: Reputation: 0
Exporting MySQL error when trying to Import to another database.


I get this error message whern trying to import my sql database. I am following al the right steps I think. Does anyone know what this means or does anyone know the rights stpes to do this. I am using PHPMyAdmin to perform this. Thank you 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----
eNoBhQR6+0VSUk9SOiBDMSBDMiBMRU46IDIgMyA5MTgKU1RSOiADCgpDVlM6ICRJZDogc3FscGFy
c2VyLmxpYi5waHAsdiAxLjkyIDIwMDMvMDkvMTAgMTc6MTM6MjkgbGVtOSBFeHAgJApNeVNRTDog
My4yMy41MgpVU1IgT1MsIEFHRU5ULCBWRVI6IFdpbiBJRSA2LjAKUE1BOiAyLjUuNApQSFAgVkVS
LE9TOiA0LjMuMyBGcmVlQlNECkxBTkc6IGVuLWlzby04ODU5LTEKU1FMOiBQSwMEFAAAAAgAS1y8
MF5MCoUgnQAA1/UDAB4AAABzdHJlemFfY29tXy1fbWlrZXMuc3FsLnppcC5zcWy8vfty3DiyJ/z/
RMw7sHX2jO3Yslz3iyZhbXA7entlWbbV7dtY6vHxGU+4USSqChZJsHlRubyx7/Q9w/dkmxeAZEll
u1KtGUe7LVUxARBIJDJ/ecF/BNkqe7k5jhKTBud/exEmbHQ7qZLsz3/6j+BK54WxadA/HB0O8INV
WWZHjx6t1+tDIEk2CkkOU13Cl/j9c1uUR0FsQxWv4Ef86JlOda5KbObCJPooeKk2QX/aCfrd7jBQ
ZdDrHQqGwfFLfPhc59Cn7/coGBz2B4ejKX715vmb4O/+8+EhfIOf4t8nqlRzVejgKPitKHP9RX0M
bfLx4cfEXOriN34M///wln+IGhu4UPNYB9BHFZZVroOFzYOSJmd0O/tNVeXqowpDXVCPSHLy9vT4
4jS4OH784nT7geD+n/8UBL8tc1tlH030W5DoyFQwleX96YPg1euL4NWvL14EkV6oKi6De917HSZx
dW90O4D+qoQIikTFMSZndDs/ehBUaWGWqY6+QUidXxm9/i0oTbpBwt63OqLnc60mcXVvdDvJ8xms
uKz9LN5ICGCSRB1EOtalllAUpQkvRWNSaWqrNBT1cmVlo8psHIewGjIqVZYqXCU6LQsJWWL3XPRf
Tt+3Wfh+8/OD5vuGY+83Pz/4858eBBfv35z++HJzdn788q/1BkPBY9JlEMGW/s7uOnt1fvr2JnF1
b3Q7OHt18fra5vr78YtfT8+D+wOQMZ2g+73/eg/+umdrwzttrTe92+Z6d9vc3b7s4E5bG93tq87u
trm7ZbreHb/s3a5Eb3ynzd3xSkzutrnvtuWb+1crG3OVxgYO252Khv/SKRnw600V46bKAC9tP5oU
jhkmbHQ7MTo1aVXoXKChUG/Zb8GVysOVync/3HpWJ8rEzeP9Eegz/jkkoiffvD17efz2PZ0ocI64
N2qdMtwrjdWdNW4cnfY7yI+da/P8r17WEE74pc2N/ooK2freLS58ctvFRdLSlLFuZr/X7e6YfXrS
5pHOv9vPdXa4tnButK2FazV9v/WLfKVuTt3Wlm7PnN/RIKbvPTt9dfr2GAyes/OTX8/Pz16/Or+H
lskKmbCrARAJ957/+vL12+D89OQCaIF0sB8pHK73zt+8fntx3qId70cL58G9i9OT56/OTmDkCvlk
P/IJvvbrF09blKP9KKc46NdPLx4fv2j3IVYoeg==
----END CUT----
----BEGIN RAW----

ERROR: C1 C2 LEN: 2 3 918
STR: 

CVS: $Id: sqlparser.lib.php,v 1.92 2003/09/10 17:13:29 lem9 Exp $
MySQL: 3.23.52
USR OS, AGENT, VER: Win IE 6.0
PMA: 2.5.4
PHP VER,OS: 4.3.3 FreeBSD
LANG: en-iso-8859-1
SQL: PKK\0^L
XXXXXXXXXX.sql.zip.sqlr8'D;uز\&z{eYXOQ$
IyQ=ddIeR_G-U1H$2y*{9{<J煱i?UYfG_C I6
IS]—s[GAlCGNuJl$(x6A 0Pe
K|\Ч()~!|'TsU(_(sE} m\7~ PXGU̓>MU
C]PHr48~t-s[eM[T0կ/^^*.{{"D1>?zTiaAH_-(MA޷:s_",H`DD:֥P /EcRij4reel2*U*\%:- Yb\_N߷Y~c7??ߜrsv~Cce:{u~"8{u_Oσ1 zgk;m_7zwݾN[eݮDo|JLW+s۝)M/m?<1:5iU\ PooÕw?zV'39$'߼={y=(p7j2+՝5n;ȏk^N͍
-.|rEҔnf}zοuvpn_k5}|nN֖nϜ =;}u _^:
 ht)߼~{qޢG ӓN`
d? O[(8O/h----END RAW----

SQL-query :

PKK\0^L XXXXXXXXX.sql.zip.sqlr8'D;uز\&z{eYXOQ$ IyQ=ddIeR_G-U1H$2y*{9{<J煱i?UYfG_C I6 IS]—s[GAlCGNuJl$(x6A 0Pe K|\Ч()~!|'TsU(_(sE} m\7~ PXGU̓>MU C]PHr48~t-s[eM[T0կ/^^*.{{"D1>?zTiaAH_-(MA޷:s_",H`DD:֥P /EcRij4reel2*U*\%:- Yb\_N߷Y~c7??ߜrsv~Cce:{u~"8{u_Oσ1 zgk;m_7zwݾN[eݮDo|JLW+s۝)M/m?<1:5iU\ PooÕw?zV'39$'߼={y=(p7j2+՝5n;ȏk^N͍ -.|rEҔnf}zοuvpn_k5}|nN֖nϜ =;}u _^:  ht)߼~{qޢG ӓN` d? O[(8O/h

MySQL said:


#1064 - You have an error in your SQL syntax near 'PK' at line 1
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Import Database Function Script Using Perl?? domquem Programming 3 01-13-2005 09:05 AM
mysql database error Tredo Linux - Security 7 11-26-2004 02:12 PM
Editing text file for import to a spread/database Franklin Programming 7 03-31-2004 06:31 AM
Import records to MySQL Database from a shell script chrisk5527 Linux - General 12 03-24-2004 09:49 PM
Exporting MYSQL results into a external files saravanan1979 Linux - General 4 11-12-2003 03:19 PM

LinuxQuestions.org > Forums > Linux Forums > Linux - Software

All times are GMT -5. The time now is 10:07 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Open Source Consulting | Domain Registration