Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Incomplete
-
10.0.11
-
None
-
None
-
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