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

import table problem

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › import table problem

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • September 25, 2003 at 8:35 pm #8180
      kbgaddis
      Member

      I have been using the SQLyog 3.6 beta over the last few days and I've found

      something i thing might be a bug.

      when I export a table to CSV, everything goes smoothly.  however, when i try

      to import the same table back into a matching structure in a different

      database (which may be a red herring; it seems to happen regardless) i get an

      error message as follows:

       Error No. 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 't' enclosed by

      '|' lines terminated by 'n'( ID, Keyboard, St

      the options i'm using for import are

      fields terminated by t

      fields enclosed by |

      lines terminated by n

      i'm attaching the error file in the sqlyog directory; i don't know if that

      will give you any additional information. let me know what else i can do to

      give you more information.

    • September 26, 2003 at 3:29 am #14957
      Ritesh
      Member

      Can you mail me the CSV file with the Table structure?

      A screenshot of the Escaping Character dialog will be nice 🙄

    • October 25, 2003 at 5:14 pm #14958
      apmuthu
      Member

      SQLYOG v3.61

      on Win98 with MSIE v6.0 SP!

      Export a table as CSV

      Import into another database's table.

      A blank record appears along with the imported data.

      SQLYOG.INI file's relevant portion:-

      Code:
      [CSVESCAPING]
      ESCAPEDBY=\
      FESCAPE=,
      LESCAPE=rn
      ENCLOSEDBY=
      ISESCAPED=1
      ISFIXED=0
      LINETERMINATED=1
      ISENCLOSED=0
      ISOPTIONALLY=0
      FIELDSTERM=1

      Ap.Muthu

    • October 26, 2003 at 8:00 pm #14959
      Ritesh
      Member

      Can you paste the LOAD LOCAL SQL syntax that SQLyog sends to the MySQL server? You can get it from the History.. tab.

  • Author
    Posts
Viewing 3 reply threads
  • You must be logged in to reply to this topic.