无法在mysql中导出rutines [英] unable to export rutines in mysql

问题描述

 11:08:54转储ors视图和/或例程和/或事件
 
运行：mysqldump.exe --defaults-extra-file =   c：\ usersrs \ jyoti \ appdata\local \ temp \tmph5btji.cnf --max_allowed_pa​​cket = 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：无法'  t执行'show create table`viewscrutinee`'：查看'ors.viewscrutinee'引用无效的表或列或功能或定义者/查看者缺乏使用它们的权利（1356）< b>< / b> ;  

解决方案

请确保您的备份用户具有显示视图权限。

< pre lang =sql> GRANT SHOW VIEW ON mydatabase。*
TO backupuser IDENTIFIED BY yourpassword;

另请参阅此 [论坛链接]了解其他可能性。

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>

解决方案

Please ensure your backup user has "SHOW VIEW" permission.

GRANT SHOW VIEW ON mydatabase.*
TO backupuser IDENTIFIED BY yourpassword;

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

这篇关于无法在mysql中导出rutines的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！