mysqldump: Got error: 1356 解决方法

QUESTION:

mysqldump: Got error: 1356: View 'yunwei.v_employee_superior' references invalid

 table(s) or column(s) or function(s) or definer/invoker of view lack rights to

use them when using LOCK TABLES

mysqldump: Couldn't execute 'SHOW FIELDS FROM `v_employee_superior`': View 'yunw
ei.v_employee_superior' references invalid table(s) or column(s) or function(s)

or definer/invoker of view lack rights to use them (1356)

ANSWER：

I would check for errors and mail/trigger something accordingly - but you can also force the backup to continue regardless of errors:

from the mysqldump reference page:

--force, -f

Continue even if an SQL error occurs during a table dump.

One use for this option is to cause mysqldump to continue executing even when it encounters a view that has become invalid because the definition refers to a table that has been dropped. Without --force, mysqldump exits with an error message. With --force, mysqldump prints the error message, but it also writes an SQL comment containing the view definition to the dump output and continues executing.