Skip to main content
commvault.com commvault.com
Solved

MySQL Backup Failing in Commvault

A
Forum|alt.badge.img+8

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

View original
Did this answer your question?

2 replies

Sunil
Vaulter
Forum|alt.badge.img+13
  • SunilVaulter
  • Vaulter
  • 300 replies
  • 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
Forum|alt.badge.img+8
  • Adarsh.op
  • Author
  • 44 replies
  • Answer
  • June 1, 2023

Hi Sunil,

Thanks for your reply

I will check and update you

Reply


Most helpful members this week

Terms & ConditionsCookie settings

Cookie policy

We use cookies to enhance and personalize your experience. If you accept you agree to our full cookie policy. Learn more about our cookies.

 
Cookie settings