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

1044 Error On Export As Sql Statment

forums › forums › SQLyog › Using SQLyog › 1044 Error On Export As Sql Statment

  • This topic is empty.
Viewing 4 reply threads
  • Author
    Posts
    • March 14, 2006 at 4:47 pm #9534
      lmneditor
      Member

      The encountered problem is this: when attempting to export data (singly or in bunches), a “1044” error box appears with the added message “Access denied to 'username'@'%' for 'databasename.' This might be related to a connection description error, but I have been unable to locate any reference to either the error number or the actual error. Since access is necessary for various functions, it's rather important that I result this issue, even though I have been able to export individual tables to CSV files.

      Suggestions appreciated.

    • March 14, 2006 at 4:56 pm #20864
      peterlaursen
      Participant

      Most likely it is a privilege issue with 'Lock tables' or 'Flush log'.

      What is your MySQL version? the LOCK_TABLE privilege was added recently and maybe user does not have it. And 'flush logs' is for use with replication primarily (and user must have replication related privileges) – though you may have a binary log also without replication.

      Try fill-out the dialogue as attached


      @Ritesh       I request that program default will be to uncheck 'lock tables' . I think this is 3rd time we have this issue since MySQL added the LOCK_TABLE privilege

    • March 14, 2006 at 5:58 pm #20865
      lmneditor
      Member
      peterlaursen wrote on Mar 14 2006, 11:56 AM:
      Most likely it is a privilege issue with 'Lock tables' or 'Flush log'.

      What is your MySQL version? the LOCK_TABLE privilege was added recently and maybe user does not have it. And 'flush logs' is for use with replication primarily (and user must have replication related privileges) – though you may have a binary log also without replication.

      Try fill-out the dialogue as attached


      @Ritesh       I request that program default will be to uncheck 'lock tables' . I think this is 3rd time we have this issue since MySQL added the LOCK_TABLE privilege

      This site is running version 3.23.49. User Manager->Edit User returns the same error as above. I will confirm user privileges with ISP.

    • March 14, 2006 at 6:11 pm #20866
      peterlaursen
      Participant
      Quote:
      User Manager->Edit User returns the same error as above

      This is very usual. Most ISP's will only let you manage user privileges from their own 'Control Panel' application. But if you don't 'lock tables' I think you will only need SELECT privilege. However to flush-hosts, flush-logs, flush-privileges, flush-status, flush-tables, flush-threads, refresh & reload you must have RELOAD privilege as well. refer to http://dev.mysql.com/doc/refman/4.1/en/pri…s-provided.html

      But are they ordinary user tables that you try to backup? If it is some kind of system tables I doubt that they will let you

      If it is a DB used by a PHP application (such as a forums software, guestbook software etc.) you should be able to log on with SQLyog using the credentials of that PHP-script.

      Also:

      if you enable batch logging from 'preferences' you should be able to see in HISTORY what was the last (unsuccessfull) command sent by SQLyog.

    • March 15, 2006 at 5:53 am #20867
      Ritesh
      Member

      By default, LOCK TABLE and all FLUSH options are unchecked in Scheduled Export Wizard.

      LOCK TABLES FOR READ is checked by default in Export Database As SQL Statements option. It will be UNCHECKED (by deafult) starting from BETA 3.

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