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 2 reply threads
  • Author
    Posts
    • February 27, 2006 at 11:45 pm #9507
      jrw
      Member

      Hi

      I am trying to export a database using the 'Export Database as SQL Statements' option in SQLyog Enterprise and get a 1044 error 'Access denied for user 'username'@'%' to database 'XYZ'.

      I can connect to the database fine and execute Select statements but cannot export the data.

      I am not using SSH (have tried it but get same result). The 'Flush Logs before Dump' option is not ticked.

      Would really appreciate a solution.

      Thanks

      John

    • February 28, 2006 at 12:24 am #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.

    • February 28, 2006 at 12:14 pm #20739
      jrw
      Member

      Peter

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

      Many thanks for your prompt response.

      John

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