MySQLDump stored procedures

[newyuppie]

im using MySQLDump control, and it doesnt dump stored procedures, is there any way to turn that option on or is it not available?
if not available, how do you suggest i proceed to do this?
thanks

[Alexey]

Set ExportAll property of MySqlDump to "true".

[KW]

Set ExportAll property of MySqlDump to "true".

Does this work? I am looking to dump stored procedures and triggers as well.

[Pinturiccio]

The ExportAll property of MySqlDump is obsolete. Use the ObjectTypes property instead.

I am looking to dump stored procedures and triggers as well.

The following sample dumps only triggers and procedures:

Code: Select all

MySqlDump mySqlDump = new MySqlDump(connection); 
mySqlDump.ObjectTypes = MySqlDumpObjects.Triggers | MySqlDumpObjects.Procedures;

For more information, please refer to http://www.devart.com/dotconnect/mysql/ ... Types.html