Database with views not backed up

[ludolugo]

Hello
I'm seeing that databases with viewes are not being backed up, i know the limitation of cpanel editing viewes but for backing up there shouldn't be anny issue, this is the error n log:

[ERROR] Failed exporting database data. Database Handler Error: Failed export MySQL database "m230046_wp_on9h2". Error: mysqldump: Couldn't execute 'SHOW FIELDS FROM `vLotesTodo`': View 'm230046_wp_on9h2.vLotesTodo' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)
mysqldump: Couldn't execute 'SHOW FIELDS FROM `vMencionesPublicadas`': View 'm230046_wp_on9h2.vMencionesPublicadas' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them (1356)

[JetAppsKevin]

Hello ludolugo,

Just to clarify, JetBackup utilizes `mysqldump` to generate the database backups, and these errors are returned during the `mysqldump` process. We would advise seeking the advice of a qualified Database Administrator to troubleshoot these errors as they would be able to assist more efficiently.

Best Regards,

[ludolugo]

If i mysqldump from phpmyadmin the database is exported without problem viewes included, i don`t think it is related to the database or the mysql server

[JetAppsKevin]

Hello ludolugo,

Thank you for the update. This `mysqldump` error appears to be unique to your server. If you have "Debug Active" enabled in Settings >> General, you can find the `mysqldump` command, including all of the options, that JB uses to generate the database backup in the logs for the affected account. To investigate further, please check if the exact command returns the same error. If so, please refer to the cPanel article below to continue troubleshooting with the assistance of a qualified MySQL administrator.

https://support.cpanel.net/hc/en-us/art ... er-invoker

Best regards,