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

Feature Request – Export In Compatibility Mode

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Feature Request – Export In Compatibility Mode

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • September 4, 2006 at 4:31 am #9830
      ray
      Member

      Hi there

      I am an Enterprise SQLyog user…

      I run MySQL 4.1.x locally, but I still administer a number of MySQL 4.0.x databases. I quite often use PHPMyAdmin to export dumps of databases in 4.0 compatibility mode.

      I cannot seem to find any option for performing this in SQLYog – am I missing something?

      Or is it just not there?

      If it isn't there, are you planning on incorporating this feature in a future release?

      Thanks

      Ray

    • September 4, 2006 at 4:47 am #22218
      peterlaursen
      Participant

      As you are an ENTERPRISE user you could use the backup 'powertool'. It will let you uncheck the UTF8 encoding that is not supported by MySQL 4.0. That will solve issues with non-ASCII characters. But you will have to edit the 'create table' syntax a little (deleting the SQL_MODE, ENGINE and DEFAULT CHARSET definitions).

      “are you planning on incorporating this feature in a future release?”

      Well. no plans actually. I think we not even discussed it. Maybe we should! And that would then also apply to 'copy to other host'.

      However 'data sync' (when table structures are created in advance) should work across versions.

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