Skip to main content
commvault.com commvault.com
Solved

MySQL Backup Failing in Commvault

  • June 1, 2023
  • 2 replies
  • 809 views
A
Novice
Forum|alt.badge.img+7

Hi Team,

 

I have facing some issue in our infra, While try to take the backup of one Mysql Databse server

we are getting below error

Current Commvault version which we are using:11.28.32

Error Description:

Backup of [DBname] MySQL database failed. The error message [mysqldump: Couldn’t execute ‘SHOW FIELDS FROM ‘visitor_cars_child_view2:View ‘DB name.visitor_cars_child_view2’

references invalid table(s) or column(s) or function (s) or definer/invoker of view lack rights to use them(1356)] is received during backup.

 

Could you please help on this above case

 

 

Best answer by Adarsh.op

Hi Sunil,

Thanks for your reply

I will check and update you

2 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • June 1, 2023

Hi @Adarsh.op 

This is returned by mysqldump process. Did you check if the MySQL user you are using has required access on the DB?

To isolate the issue, you can run mysqldump outside Commvault using the same user login.

 

Thanks,

Sunil-

A
Novice
Forum|alt.badge.img+7
  • Adarsh.opNovice
  • Author
  • Novice
  • Answer
  • June 1, 2023

Hi Sunil,

Thanks for your reply

I will check and update you

Terms & ConditionsCookie settingsAccessibility statement