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

Export Database – Error 1044

forums forums SQLyog SQLyog: Bugs / Feature Requests Export Database – Error 1044

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • #20738
      peterlaursen
      Participant

      Two ways

      1) Also uncheck 'Lock all tables for read'.

      2) Grant user LOCK_TABLES privilege. I think that this is a reather new privilege that you cannot manage from SQLyog. Use commandline client or MySQL Administrator as long as SQLyog does not support it!

      Both methods have been tested here on MySQL 5.1.6 as a user having only SELECT (and LOCK_TABLES for 2nd way) only.


      @ritesh
      : I think that 'Lock all tables for read' is CHECKED as DEFAULT. I think it should not be as long as SQLyog does not support the privilege from User Management.

    • #20739
      jrw
      Member

      Peter

      That's great, thanks. Option 1 worked a treat.

      Many thanks for your prompt response.

      John

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