Bug #28540 mysqdump --verbose does not provide informations about triggers and stored procs

• Submitted: 20 May 2007 9:20
• Modified: 30 Sep 2008 16:17
• Reporter: [ name withheld ] (Basic Quality Contributor)
• Status: Verified
• Category: MySQL Server: Command-line Clients
• Severity: S4 (Feature request)
• Version: 5.0, 5.1, 6.0
• OS: Linux (any OS)
• CPU Architecture: Any
• Tags: mysqldump, stored procedure, trigger, verbose

[20 May 2007 9:20] [ name withheld ]

Description:
Hi, while dumping some databases I noticed that mysqldump with the --verbose option doesn't provide info about triggers and stored procedures.
It should be useful for a verbose option to show infos about every part of the process.
Thanks in advance.

How to repeat:
It can be repeated by dumping any database with a stored procedure and a trigger using the --routines and --verbose options.

[21 May 2007 9:59] Sveta Smirnova

Thank you for the reasonalbel feature request.

[30 Sep 2008 16:17] Susanne Ebrecht

CREATE TABLE t(id SERIAL);
INSERT INTO t VALUES (1),(2),(4),(5),(6);
DELIMITER §
CREATE TRIGGER t_t BEFORE INSERT ON t FOR EACH ROW BEGIN SET NEW.id=NEW.id; end§
CREATE PROCEDURE p() BEGIN INSERT INTO t VALUES(); END§
CREATE FUNCTION f() RETURNS INTEGER BEGIN RETURN 23; END§
DELIMITER ;

$ ./bin/mysqldump -v --triggers=TRUE --routines=TRUE <your database> > <your_dumpfile>

-- Connecting to localhost...
-- Retrieving table structure for table t...
-- Sending SELECT query...
-- Retrieving rows...
-- Disconnecting from localhost...

Still non output about trigger or routines at verbose mode.