AnsweredAssumed Answered

Error when mysqldump ca_uim on mysql

Question asked by XITO on Apr 15, 2016
Latest reply on Apr 25, 2016 by XITO

Hi everyone

We built a new environemenmt wirth CA_UIM 8.31 database on mysql/Opensuse 13.2.

Whe I try to backup the database the follwing error occures:

 

mysqldump: Couldn't execute 'SHOW FIELDS FROM `pbmv_configstate`': View 'ca_uim.pbmv_configstate' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

 

This are the mysqldump options used:

[mysqldump]

create-options

compress

flush-logs

all-databases

skip-lock-tables

 

Any idea how to fix this?

 

Thanks


Daniel

Outcomes