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

Backup As Sql Dump (data Only) Problem

forums › forums › SQLyog › SQLyog: Bugs / Feature Requests › Backup As Sql Dump (data Only) Problem

  • This topic is empty.
Viewing 2 reply threads
  • Author
    Posts
    • May 15, 2007 at 12:28 am #10335
      Don Señor
      Member

      BackUp DataBase As SQL Dump (DATA ONLY), also exports VIEWs data giving me in my case an

      “Error Code: 1288 – The target table vordenesdepago of the INSERT is not updatable” error

      Suposing my views where updatable, exporting its data is useless, resulting in bigger dump files and slower export/import.

      There is an old post about this issue:

      [topic=”3034″] Bug: Export Table Data Also Exports View Data[/topic]

      It also dosen't ignore 5.x Objects check options, exporting VIEWs structures and routines (if checked), and I think it would cause an “VIEW/PROCEDURE already exist” error, in case that the import could reach that part of the script, because a data only dump is for sure going to be imported into existent database/s

      Example file attached.

      Thanks!

    • May 15, 2007 at 4:20 am #23995
      Manoj
      Member

      Hello,

      Bug confirmed. This issue will be fixed in the next release.

    • May 16, 2007 at 4:12 am #23996
      adarsh
      Member

      Hello,

      This issue is fixed in SQLyog 5.31.

      Thanks

      Adarsh

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