MySQLDump stored procedures

MySQLDump stored procedures

Postby 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
newyuppie
 
Posts: 13
Joined: Fri 07 Jul 2006 05:48

Postby Alexey » Tue 11 Jul 2006 09:01

Set ExportAll property of MySqlDump to "true".
Alexey
 
Posts: 2756
Joined: Mon 13 Mar 2006 07:43

Re:

Postby 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.
KW
 
Posts: 123
Joined: Tue 19 Feb 2008 19:12

Re: MySQLDump stored procedures

Postby 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/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlDump~ObjectTypes.html
Pinturiccio
Devart Team
 
Posts: 2020
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL