Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Importing Sql With Blob In Phpmyadmin

forums › forums › SQLyog › Using SQLyog › Importing Sql With Blob In Phpmyadmin

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • June 29, 2009 at 5:15 pm #11567
      moijisi
      Member

      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?

    • June 29, 2009 at 5:58 pm #29246
      peterlaursen
      Participant

      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
Viewing 1 reply thread
  • You must be logged in to reply to this topic.