Could we have an option to get rid of database names in exported SQL dumps:
-- Dumping structure for table dbname.table
-- Dumping structure for view dbname.view
-- Dumping structure for function dbname.func
-- Dumping structure for event dbname.event
... and probably some other similar comments for procedures and other objects?
I know these names are in comments but sometimes I need to compare database structure between development and production servers so I export both databases without data and use an external program to see the differences. Most often the database names are different between the development and production and therefore I see unnecessary changes in the diff for all database objects and it's more difficult to find the real differences. Could something be done about it?
Personally, I don't see any sense in those comments at all - when I see a CREATE TABLE command in the dump it's obvious that this is table structure, I don't need a comment "Dumping structure for table...". But I don't mind if they stay as long as they don't interfere with diffs.