Bug #62069 adding schema name in mysqldump output

• Submitted: 3 Aug 2011 9:14
• Modified: 3 Aug 2011 9:43
• Reporter: Shantanu Oak
• Status: Verified
• Category: MySQL Server: mysqldump Command-line Client
• Severity: S4 (Feature request)
• Version: any
• OS: Any
• CPU Architecture: Any
• Tags: mysqldump, oksoft

[3 Aug 2011 9:14] Shantanu Oak

Description:
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.