Details
-
Type:
Bug
-
Status: Closed
-
Priority:
Major
-
Resolution: Incomplete
-
Affects Version/s: 10.0.11
-
Fix Version/s: N/A
-
Component/s: None
-
Labels:None
-
Environment:Ubuntu 12.04
Description
mysqldump and view incompatible when the user who created the view and the user who made the dump are different.
example :
mysqldump -h 10.10.6.2 -P 3306 -u dba -p --quick --add-drop-table --no-data --default-character-set=utf8 --extended-insert --master-data=2 --single-transaction PRODUCTION > ff
result
mysqldump: Couldn't execute 'show table status like 'VIEW\_CUSTOMER\_PBX\_ORDER': SELECT command denied to user ''@'%' for column 'SKU' in table 'PROD_ITEMS' (1143) GLI-018 : CMD FAIL ! : mysqldump -h 10.16.60.254 -P 3306 -u dba -p --quick --add-drop-table --default-character-set=utf8 --extended-insert --master-data=2 --single-transaction PRODUCTION > /data/backup/10.16.60.254/PRODUCTION/2014-06-10_170000__PRODUCTION.sql
quick fix : the user who made the backup must create the view (only the problem with MariaDB)
referenced and fixed in MySQL 5.6.16
http://bugs.mysql.com/bug.php?id=70907
http://bugs.mysql.com/bug.php?id=17089
Gliffy Diagrams
Attachments
Activity
- All
- Comments
- Work Log
- History
- Activity
- Transitions
Are bug numbers correct?
Bug#70907 is "mysqldump: Couldn't execute 'show table status': SELECT command denied to user'" and as of today it's still Open, not fixed in 5.6.16.
Bug#17089 is "mysqldump will not dump a db with more than 247 tables on Mac OS X" and it was closed eight years ago with "No Feedback" status, not fixed anywhere.