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

Forums | Webyog

Tools to manage and monitor MySQL databases

Export View Fails

This topic is empty.

Viewing 5 reply threads

Author

Posts
- January 7, 2016 at 5:57 pm #35606
  
  Keith Davis
  Participant
  
  No ideas?
- January 19, 2016 at 10:38 am #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]
- January 19, 2016 at 1:43 pm #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]
- January 19, 2016 at 2:58 pm #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;”
- January 19, 2016 at 5:47 pm #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 
```
- January 19, 2016 at 6:15 pm #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. 🙂
Author

Posts

Viewing 5 reply threads

You must be logged in to reply to this topic.