mysqldump: Got error: 1356

mysqldump 备份遇到下述错误：

mysqldump: Got error: 1356: View 'test.a_lookup' references invalid table(s)
or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES

mysql中访问这个视图，错误如下：
mysql> select * from a_lookup;
1356 - View 'test.a_lookup' references invalid table(s) or column(s)
 or function(s) or definer/invoker of view lack rights to use them

检查发现视图定义有误：
本应是：select * from test1.tablea;
误写为：select * from test.tablea;

而test库中并没有testa这个表，修正后问题解决。