Importing Sql With Blob In Phpmyadmin

[moijisi]

I'm not able to import exported data SQL with Blob data in PhpMyAdmin.

I have error:

Code:

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—-
eNrt0d1LU3EYB/CFQnIuyousm7LfhSmEO3rmdPOMGEuGmZtbTl0IuixXDebmy0yPzq2ILirIIg1s
pEKh1MCBBRE5D2QaaSpd2IilI0czNd18m+7lHNv6I7p64OG5eH4vXx4+0tJSRSmJCghUwEMyaQmJ
chAf5fOJXExVFjtIwDBVRWyaVlRLoqYGfX1NY5O2EdfrLuP11+sRQWQTAsTLzhZwCR6XRyBCSMaK
z69Eem1dPkrD5JTqgoxEuXg2nifgXjHW1TUbdCYKK1eVIoUqE0kKpSVlmahCGgtT6wxIrqgskskk
8QeYUi4hEQ8nCJyPKc8p45cyFar4ZzxciGQ6Q3MrJpOUFJJIa+A2m65yhdi/MExZnJB4hMPhJHE+
KOfJs2eqvN1fEjhrL5M48WkNX5ibx+PlaHQGk7bRYMRje/1xuodTP1ED1Lr94teMrvSGZqNJlHhD
W6GteCI6TqAkgz65/8DD+eDdrvIeqSMp+dLNfv2qyVA7VIPX+CZ81KaGc/TFqclFmWL7lrwn8VtY
0N3j8XXQVQvvW3bG6GhgjvYYPRp6pC3Y2TmUfs0kYpYjJ1nfgtPu2XWJq+k2KkV86Kd3vC86ZROI
o2tWxrEfjhXhD7Eeuz+0p7WOZTHMMYfFvPVWnVV9YmecDhRatynrd41LYJnZWvVHPNUMozAvBm12
odxd3tGUMkA/25xjHOaN1+zTrI7IuLW9Ox7dG28zdjoUvu9wjHbse/caQjaaCgbezUbcjl5zOOBn
p7wZtHN/eiuDZoLsc2MqG/zs9bBbY4MKdsoasdkKI29GX7Yzjw7uVVWdnyRmaKclNEBbQistox9d
PyJ39neDol4XI6XDG9OrfQ8EYue6esnuUhsnZi1qTdRttJKzNsfIqPnX7cHDfrG1dSfKZnSmssvF
Q5YdgVpNR4aZ9Xt90dNMeGXj8ZK6k6a2f79it30pWSIABmAABmAABmAABmAABmAABmAABmAABmAA
BmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAABmAA
BmAABmAABmAABmAA/h/AfwG06GIY
—-END CUT—-
—-BEGIN RAW—-

ERROR: C1 C2 LEN: 3 4 9415
STR:

SVN: $Id: sqlparser.lib.php 11017 2007-12-21 18:18:44Z lem9 $
MySQL: 5.0.67-community
USR OS, AGENT, VER: Win MOZILLA 5.0
PMA: 2.11.4
PHP VER,OS: 5.2.8 Linux
LANG: en-utf-8
SQL:
……………………….
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 'PK' at line 1

How to solve?

[peterlaursen]

well .. we do not support phpMyAdmin here. We support our own programs. Was the dump created with SQLyog?

You may read:

http://www.webyog.com/blog/2008/07/29/phpmyadmin-for-sale/ .. what summarizes our position on that program. But if some other user can support this, then no problem with us.

But I think it could very well be a encoding issue (file encoding, charset for the connection and/or browser encoding setting conflict). This “near 'PK'” seems to indicate such thing. Do you know how the file is encoded? Then select a corresponding encoding in the browser and also ensure that there is an appropriate SET NAMES statement.

I suggest that you try to import SQLyog (with or without HTTP-tunnelling)

[Author]

Posts