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

Can't sync between MySQL 4.0 and MySQL 4.1

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Can't sync between MySQL 4.0 and MySQL 4.1

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • February 14, 2005 at 10:11 pm #8799
      c64audio
      Member

      I'm finding that “Copy Table to different DB” and the Synchronisation Wizard are failing when the source database is MySql 4.1 (4.1.6-gamma NT) and the target is MySql 4.0 (4.0.22). The difficulty is in the “Charset” command that's put in the table definition, which isn't recognised by 4.0 and generates an error. But I can't find a way to get it to ignore this behaviour 🙁 The tables are ISAM tables.

      Converting to InnoDB isn't an option (yet), and getting a Mysql db upgrade to 4.1 on the target server is also not an option (yet).

      Only way is to create a huge batch file and then search/replace for the offending bit, I guess. Irritating.

      I'm currently upgrading 4.1.6 to 4.1.9, but I'm not hopeful it will solve the problem because they broke MySql 4.0 with MySql 4.1.

      Chris

    • February 15, 2005 at 3:08 am #17020
      Ritesh
      Member

      This is a known issue and we are working on it.

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.