Bug #62069 adding schema name in mysqldump output
Submitted: 3 Aug 2011 9:14 Modified: 3 Aug 2011 9:43
Reporter: Shantanu Oak Email Updates:
Status: Verified Impact on me:
Category:MySQL Server: mysqldump Command-line Client Severity:S4 (Feature request)
Version:any OS:Any
Assigned to: CPU Architecture:Any
Tags: mysqldump, oksoft

[3 Aug 2011 9:14] Shantanu Oak
I have the same table name across several schema and when I process the dump output, it is not possible to know which schema does it relate to.
Is it possible to add a switch to mysqldump command that will add the database name to the generated statements? 
insert into db_name.tbl_name

instead of 
use db_name
insert into tbl_name

How to repeat:
mysqldump --all-databases

Suggested fix:
mysqldump --all-databases --add-schema-name
[3 Aug 2011 9:43] Valeriy Kravchuk
Thank you for the feature request.