hi ,
I am trying to take BACKUP of the database ....
in test database,i am having one VIEW table.
Thanks in advance........ ...
I am trying to take BACKUP of the database ....
Code:
shell>mysqldump -u root -ppassword test>test.sql mysqldump: Got error: 1356 : View 'test.viewpattern' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them when using LOCK TABLES
in test database,i am having one VIEW table.
Thanks in advance........ ...