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

Jade Db To Mysql Migration

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Jade Db To Mysql Migration

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • August 26, 2010 at 7:30 am #31267
      Khushboo
      Member

      Hi Scott,

      Quote:
      In the log SQLyog seems to use lowercase for the 'select' but capitals for the 'FROM' clause. How can I force uppercase for this?

      There is no way to select a case for the keywords in the queries written in log file.

      But you are absolutely correct that there is inconsistency as FROM and SELECT both are keywords and still there is difference in cases.

      We will change this behavior from next release and make sure that SELECT is also in UPPER CASE along with other keywords in the queries which we are framing while importing.

      Thank You.

      Regards,

      Khushboo

    • September 1, 2010 at 8:47 pm #31268
      Scott Thompson
      Member

      Great, thanks for that. How often are new releases?

    • September 2, 2010 at 5:52 am #31269
      Khushboo
      Member

      Hi Scott,

      This fix will be included in next public release 8.61 GA, releasing probably today.

      Thank You.

      Regards,

      Khushboo

    • September 3, 2010 at 4:47 am #31270
      Khushboo
      Member

      Hi,

      We have released 8.61 GA with this fix.

      “Import external data now always uses UPPERCASE for keywords in queries sent to the ODBC-source as some ODBC-sources require this.”

      Please refer to:

      http://www.webyog.com/blog/2010/09/02/sqlyog-mysql-gui-8-61-released/

      Thanks & Regards,

      Khushboo

    • September 30, 2010 at 12:44 am #31271
      Scott Thompson
      Member

      Thanks heaps, I updated and it seems to run now, I did about 20 tables with no issue. I then tried doind the entire database and it ran for about an hour then I received an error “Not enough memory, application terminated!” Any ideas?

      Thanks.

    • October 1, 2010 at 6:28 am #31272
      Khushboo
      Member

      Hi Scott,

      Thank you for verifying the fix.

      Quote:
      I then tried doing the entire database and it ran for about an hour then I received an error “Not enough memory, application terminated!”

      We actually did some code optimization in version 8.61 which solved “Not enough memory” issue. But in case you are still getting this issue then please let us know:

      1) What is the size of the database which you are trying to Import? (number of tables and maximum row size in case tables have blob/text data-types)

      2) Is it happening for a particular table? If yes then please send us the structure of the table and let us know the maximum row size of the table.

      3) How much physical memory do you have?

      Regards,

      Khushboo

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