Page 1 of 1
MySQLDump stored procedures
Posted: Mon 10 Jul 2006 15:11
by 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
Posted: Tue 11 Jul 2006 09:01
by Alexey
Set ExportAll property of MySqlDump to "true".
Re:
Posted: Tue 07 Aug 2012 16:19
by KW
Alexey wrote:Set ExportAll property of MySqlDump to "true".
Does this work? I am looking to dump stored procedures and triggers as well.
Re: MySQLDump stored procedures
Posted: Thu 09 Aug 2012 12:24
by Pinturiccio
The ExportAll property of MySqlDump is obsolete. Use the ObjectTypes property instead.
KW wrote: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