mysqldump: Got error: 1356: View \'goolen.v

ny3259

一网友使用mysqldump导出数据的时候，由于试图引用的表被drop，导出过程出现问题，模拟如下：　　[iyunv@goolen ~]# mysqldump -uroot -pxxx goolen > goolen.sql              
　　mysqldump: Got error: 1356: View 'goolen.v_dbstatus' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
　　
　　[iyunv@goolen ~]# mysqldump -uroot -pxxx --force goolen > goolen.sql        
　　mysqldump: Got error: 1356: View 'goolen.v_dbstatus' 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_dbstatus`': View 'goolen.v_dbstatus' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
　　
　　查看试图的定义：
　　mysql> show create view v_dbstatus;
　　ERROR 1046 (3D000): No database selected
　　mysql> use goolen;
　　Database changed
　　mysql> show create view v_dbstatus;
　　+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
　　| View       | Create View                                                                                                                                                                                                                             | character_set_client | collation_connection |
　　+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
　　| v_dbstatus | CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `v_dbstatus` AS select `goolen`.`dbstatus`.`id` AS `id`,`goolen`.`dbstatus`.`host` AS `host`,`goolen`.`dbstatus`.`db_type` AS `db_type` from `dbstatus` | utf8                 | utf8_general_ci      |
　　+------------+-----------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------+----------------------+----------------------+
　　1 row in set, 1 warning (0.00 sec)
　　
　　检查发现该试图引用的表已经不存在；
　　mysql> desc dbstatus;
　　ERROR 1146 (42S02): Table 'goolen.dbstatus' doesn't exist
　　
　　删除该试图：
　　mysql> drop view v_dbstatus;
　　Query OK, 0 rows affected (0.01 sec)
　　
　　mysql> exit
　　Bye
　　[iyunv@goolen ~]# mysqldump -uroot -pxxx goolen > goolen.sql