[MDEV-6331] mysqldump & show table status like Created: 2014-06-11  Updated: 2014-09-05  Due: 2014-06-25  Resolved: 2014-09-05

Status: Closed
Project: MariaDB Server
Component/s: None
Affects Version/s: 10.0.11
Fix Version/s: N/A

Type: Bug Priority: Major
Reporter: Aurélien LEQUOY Assignee: Unassigned
Resolution: Incomplete Votes: 0
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

 Comments   
Comment by Sergei Golubchik [ 2014-06-11 ]

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.

Generated at Thu Feb 08 07:11:05 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.