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

copy database error

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › copy database error

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • December 6, 2004 at 2:41 pm #16647
      Ritesh
      Member

      SQLyog uses the query returned from “CREATE TABLE…” SQL to create tables between two hosts. It looks like the SQL returned from 4.0.17 is not compatible with 4.1.7.

      I have forwarded the issue to my development team.

    • December 6, 2004 at 2:52 pm #16648
      reinaldo
      Member
      Ritesh wrote on Dec 6 2004, 02:41 PM:
      SQLyog uses the query returned from “CREATE TABLE…” SQL to create tables between two hosts. It looks like the SQL returned from 4.0.17 is not compatible with 4.1.7.

      I have forwarded the issue to my development team.

      Ok, but I using from 4.1.7 to 4.0.17. Not from 4.0.17 to 4.1.7.

    • December 6, 2004 at 3:57 pm #16649
      Ritesh
      Member

      Oops. My mistake. I actually meant 4.1.7 to 4.0.17.

      The SQL returned from 4.1.7 is not backward compatible. Therefore, they dont work with 4.0.17.

    • December 7, 2004 at 11:06 am #16650
      Shadow
      Member

      Replace the ENGINE keyword with TYPE and the CREATE TABLE statement will work as expected, unless you have some timestamp columns.

      Ritesh: SQLyog could detect the versions and do this conversion automatically!

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