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

Issues Creating Views

forums › forums › SQLyog › Using SQLyog › Issues Creating Views

  • This topic is empty.
Viewing 3 reply threads
  • Author
    Posts
    • October 27, 2010 at 12:42 pm #31466
      peterlaursen
      Participant

      It is the MySQL server that adds this. It is not a SQLyog issue.  

      Same would happen when you execute same CREATE VIEW statement from any client. 

      Refer: 

      http://dev.mysql.com/doc/refman/5.1/en/create-view.html

    • October 27, 2010 at 12:48 pm #31467
      peterlaursen
      Participant

       You get the error because DEFINER on source does not exist on target.. But we have this request already:

      http://code.google.c…s/detail?id=324 (what would then create DEFINER as 'SQLyog user')

      SQL_SECURITY for a VIEW (as well as for a STORED PROCEDURE etc.) is either INVOKER or DEFINER.  The server cannot  handle privileges for a VIEW without a DEFINER.  In particular not if SQL_SECURITY is DEFINER.

    • October 28, 2010 at 6:11 pm #31468
      paulbrown79
      Member

      Hey Guys

      Thanks for your comments.

      What is best method for moving views between servers?

      Cheers

      Paul

    • October 28, 2010 at 6:23 pm #31469
      peterlaursen
      Participant

      I think there is no general answer to that. If the servers have the same users, SQLyog Schema Sync will handle.  If not the case you will have to edit the sync script (replacing DEFINER).

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