Bug #57500 DUMP does not work
Submitted: 16 Oct 2010 19:48 Modified: 20 Jan 2012 7:39
Reporter: Ashr Ben Email Updates:
Status: Closed Impact on me:
None 
Category:MySQL Workbench: Administration Severity:S1 (Critical)
Version:5.2.29 OS:Any
Assigned to: Alfredo Kojima CPU Architecture:Any

[16 Oct 2010 19:48] Ashr Ben
Description:
Cant backup stored Procedures and Events.    
There were many files missed and 242 tables completed and 256 tables selected

How to repeat:
using 5.5.6RC 

Create a New Database;
Add a Stored Procedure;
Add an Event;

---there are data tables--- Separation of Code and data!

back up using clicks on bottom for dumps views and dump Stored Routines. 

Error message: Nothing to do, no schemas or tables selected. 

Suggested fix:
Fix so I can backup SP and events!

If 5.5.6RC is close to being completed, then if ppl migrate and find that SP and events are missed. 

Ppl will drop MySQL as a choice of DB options, Like I am doing right now. I am wasting my time trying to figure out workarounds for a simple task.

FIX MysqlDUMP!  FIX data dump.
[16 Oct 2010 19:50] Ashr Ben
There are NO data in Db that have SP and events!
[16 Oct 2010 20:16] Peter Laursen
Also see http://bugs.mysql.com/bug.php?id=57451

Peter
(not a MySQL person)
[15 Nov 2010 16:31] Alfredo Kojima
Fixed so that dumps can happen without any tables.
[3 Jun 2011 17:13] Yvan Rodrigues
Confirming: Still present in 5.2.33 -- cannot dump stored procedures unless one or more tables are selected.
[20 Jan 2012 7:39] Philip Olson
Fixed as of 5.2.37:

The export feature would sometimes fail when exporting tables with stored
procedures, and with Dump Stored Procedures checked. And also having
Export as Dump Project Folder selected would result in an unhandled 
exception.