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

Export View Fails

forums forums SQLyog Using SQLyog Export View Fails

  • This topic is empty.
Viewing 5 reply threads
  • Author
    Posts
    • #35606
      Keith Davis
      Participant

      No ideas?

    • #35607
      peterlaursen
      Participant

      Sorry for the late reply. We will try to reproduce “but only if I export all databases [including ‘mysql’]”.

       

      However please:

      1) tell the server version. 

      2) are underlying tables MyISAM or InnoDB? 

      3) Your settings for lock and flush on source. Please see image. [attachment=2056:lockandflush.PNG]

       

    • #35608
      Keith Davis
      Participant

      MySQL 5.6.26

      InnoDB

       

      I’m not using Backup Databases as SQL Dump, I’m using Scheduled Backups.

       

      [attachment=2057:Capture.JPG]

       

       

       

       

    • #35609
      peterlaursen
      Participant

      OK …we will try to dig into this.  Are you ‘root’@’localhost’ when backing up? And does he/you have privileges to underlying tables? Simply connect (as same user) and execute “SHOW GRANTS;”

    • #35610
      Keith Davis
      Participant

       

       

      Are you ‘root’@’localhost’ when backing up? 

       

      No. 

       

      mysqlbackup@[email protected]

       

       

      And does he/you have privileges to underlying tables?

       

      I thought so, but now that I look at these again, I believe that the problem is that this user needs execute, right? The problem is, why doesn’t this fail if run by that same user for only that view?


      SHOW GRANTS;

      GRANT SELECT, LOCK TABLES, SHOW VIEW ON *.* TO 'mysqlbackup'@'app02.pridedallas.com' IDENTIFIED BY PASSWORD
    • #35611
      Keith Davis
      Participant

      So, that was the problem. Still don’t understand my test results though (which is why I didn’t check grants further), but oh well. 🙂

Viewing 5 reply threads
  • You must be logged in to reply to this topic.