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

Problems with importing/exporting

forums › forums › SQLyog › Using SQLyog › Problems with importing/exporting

  • This topic is empty.
Viewing 7 reply threads
  • Author
    Posts
    • May 15, 2003 at 8:43 am #7939
      kjelle392
      Member

      I have one database at my desktop that I need to transfer/synchronize to my laptop.

      I use Export database as batch scripts to accomplish this, but when I try to import this file into SQLyog at my laptop, I get an error about “charset=latin” and the process terminates…

      Do I do anything wrong here, or is this a bug?

      SQLyog is a fantasic tool and this error/problem is the ONLY thing I have to put my finger on 🙂

    • May 15, 2003 at 2:17 pm #14291
      Ritesh
      Member

      Hello

      SQLyog writes the query and the error in sqlyog.ini. The file is located in the directory where SQLyog is installed. Can you give us the exact error with query?

    • May 15, 2003 at 2:47 pm #14292
      kjelle392
      Member

      I can't find the query+error in the ini-file, but heres a bit of the text in the messages-window:

      Error Code : 1064

      You have an error in your SQL syntax near 'character set latin1 NOT NULL default '', 'passord' varchar(30) character set ' at line 9 (5 ms taken)

      Error Code : 1146

      Table 'personprofil.admin' doesn't exist (5 ms taken)

      Error Code : 1064

      You have an error in your SQL syntax near 'character set latin1 NOT NULL default '', 'beskrivelse' text character set ' at line 9 (5 ms taken)

      … The errors 1146 and 1064 are repeated.

      The query is 392 kB .. 🙂

    • May 15, 2003 at 3:42 pm #14293
      Ritesh
      Member

      Hello

      Are you using Tools->Execute Batch File… option or you are using the SQL Window to execute the queries.

    • May 15, 2003 at 6:53 pm #14294
      kjelle392
      Member

      I export the database using export database as batch script from PC#1, and then choose Open at the PC#2. Then I use SHIFT+F5

    • May 17, 2003 at 6:19 am #14295
      kjelle392
      Member

      Is there no solution for this? 😮

    • May 17, 2003 at 9:36 am #14296
      Ritesh
      Member

      Hello

      We looked into your .SQL file. One of the table data has lot of escaped data which our parser is not able to detect properly.

      We are working on it and most probably will be fixed in SQLyog 3.2 which we are going to release next month.

      HTH

    • May 17, 2003 at 11:40 am #14297
      kjelle392
      Member

      Great!

      I'm looking forward to that – SQLYog is the best admin-tool for MySQL 🙂

      Keep up the good work!

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