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) Email Updates:
Status: Verified Impact on me:
None 
Category:MySQL Server: Command-line Clients Severity:S4 (Feature request)
Version:5.0, 5.1, 6.0 OS:Linux (any OS)
Assigned to: 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.