mysqldump Couldn’t execute references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them

3 cases

• The view is “corrupted” (this could happen if the table the view is of has been updated in a way so that the view is no longer correct – for instance if the table structure is updated)
• The user you are using are lacking permissions (to the view/table (that the view is referencing) ) (Refer : http://gubendran.blogspot.com/2012/02/create-user-in-mysql-and-provide.html for user creation and permission)
• Somecases view must have created based on the user definer. In this case drop the view and create the view without having definer. This is safe. Always avoid using definer on table, view, trigger and procs creation.