MySQL DUMP View Sequence

[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

[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