MySQL DUMP View Sequence

MySQL DUMP View Sequence

Postby NSY738 » Wed 05 Apr 2017 08:26

HI

I follow guide on this page. http://www.devart.com/dotconnect/mysql/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlDump.html

now i can backup the database. but when i try to restore the database it will show
Table 'xxxx.v_omdoc' doesn't exist SQL.sql 8152 760


After i checked the problem is sequence of view in the file.

Have any method i can skip the error and continue apply?

Thank you
NSY738
 
Posts: 3
Joined: Fri 24 Feb 2017 06:08

Re: MySQL DUMP View Sequence

Postby Pinturiccio » Fri 07 Apr 2017 14:39

You can use the Error event to process and ignore an error. For more information, please refer to https://www.devart.com/dotconnect/mysql/docs/?Devart.Data.MySql~Devart.Data.MySql.MySqlDump~Error_EV.html

If you add the following line to the myDump_Error function, the error will be ignored, and the script will continue to run:
Code: Select all
e.Ignore = true;

For more information, please refer to https://www.devart.com/dotconnect/mysql/docs/?Devart.Data~Devart.Common.ScriptErrorEventArgs~Ignore.html
Pinturiccio
Devart Team
 
Posts: 1860
Joined: Wed 02 Nov 2011 09:44


Return to dotConnect for MySQL