MySQLDump stored procedures

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
newyuppie
Posts: 13
Joined: Fri 07 Jul 2006 05:48

MySQLDump stored procedures

Post by newyuppie » Mon 10 Jul 2006 15:11

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
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Post by Alexey » Tue 11 Jul 2006 09:01

Set ExportAll property of MySqlDump to "true".

KW
Posts: 125
Joined: Tue 19 Feb 2008 19:12

Re:

Post by KW » Tue 07 Aug 2012 16:19

Alexey wrote:Set ExportAll property of MySqlDump to "true".
Does this work? I am looking to dump stored procedures and triggers as well.

Pinturiccio
Devart Team
Posts: 2192
Joined: Wed 02 Nov 2011 09:44

Re: MySQLDump stored procedures

Post by Pinturiccio » Thu 09 Aug 2012 12:24

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

Post Reply