Bug #79522 can mysqldump print the fully qualified table/procedure names in the dump
Submitted: 4 Dec 2015 11:48 Modified: 14 Dec 2015 12:32
Reporter: Shane Bester (Platinum Quality Contributor) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:8.0.0 OS:Any
Assigned to: CPU Architecture:Any

[4 Dec 2015 11:48] Shane Bester 
Description:
we often ask for a mysqldump --routines --no-data --triggers --events --all-databases output from customer to get their schema

schema's are often duplicated, and finding the correct table means first finding the correct database in the dump, then searching forward and hoping you didn't miss it.

e.g.

E:\mysql-5.7.9-winx64\bin>mysqldump --all-databases --no-data -P3307 | grep t1
-- Table structure for table `t1`
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
-- Table structure for table `t1`
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (
-- Table structure for table `t1`
DROP TABLE IF EXISTS `t1`;
CREATE TABLE `t1` (

How to repeat:
.

Suggested fix:
please just print the full qualified name like this, so we can search:

-- Table structure for table `test`.`t1`

-- Table structure for table `a`.`t1`

-- Table structure for table `b`.`t1`
[14 Dec 2015 12:32] MySQL Verification Team 
Hello Shane,

Thank you for the feature request!

Regards,
Umesh
[18 Jun 2016 21:35] Omer Barnir 
Posted by developer:
 
Reported version value updated to reflect release name change from 5.8 to 8.0