MySQL DUMP View Sequence

Discussion of open issues, suggestions and bugs regarding ADO.NET provider for MySQL
Post Reply
NSY738
Posts: 4
Joined: Fri 24 Feb 2017 06:08

MySQL DUMP View Sequence

Post by NSY738 » Wed 05 Apr 2017 08:26

HI

I follow guide on this page. http://www.devart.com/dotconnect/mysql/ ... lDump.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

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

Re: MySQL DUMP View Sequence

Post by 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 ... or_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 ... gnore.html

Post Reply