Click here to Skip to main content
16,001,721 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
VB
11:08:54 Dumping ors views and/or routines and/or events

Running: mysqldump.exe --defaults-extra-file="c:\users\jyoti\appdata\local\temp\tmph5btji.cnf"  --max_allowed_packet=1G --host=localhost --user=root --complete-insert=TRUE --port=3306 --default-character-set=utf8 --skip-triggers  --no-data  --no-create-db --routines --events "ors" "viewcollege_master" "dist_cast" "viewscrutinee" "view_interview_report" "viewapp" "viewsociety_master"

mysqldump: Couldn't execute 'show create table `viewscrutinee`': View 'ors.viewscrutinee' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)<b></b>
Posted

1 solution

Please ensure your backup user has "SHOW VIEW" permission.
SQL
GRANT SHOW VIEW ON mydatabase.*
TO backupuser IDENTIFIED BY yourpassword;

Also refer to this [Forum Link] for other possibilities.
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900