Page 1 of 1

MySQL DUMP View Sequence

Posted: Wed 05 Apr 2017 08:26
by NSY738
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

Re: MySQL DUMP View Sequence

Posted: Fri 07 Apr 2017 14:39
by Pinturiccio
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