<html>
<head>
<meta http-equiv="content-type" content="text/html; charset=UTF-8">
</head>
<body>
Hi all,<br>
We recently upgraded from v5.8 to v6.0.0 and we bumped into a very
strange issue with regards to the database backup process.<br>
<br>
Specifically, using the backup notes available in the IXPM website (<a
href="https://docs.ixpmanager.org/usage/operational-notes/#backup-ixp-manager)"
class="moz-txt-link-freetext">https://docs.ixpmanager.org/usage/operational-notes/#backup-ixp-manager)</a>
mysqldump command returns the following error:<br>
<br>
<i>mysqldump: Couldn't execute 'SHOW FIELDS FROM
`view_cust_current_active`': View
'ixpmanager6.view_cust_current_active' references invalid table(s)
or column(s) or function(s) or definer/invoker of view lack rights
to use them (1356)</i><br>
<p>Note that we didn't face any issue during the upgrade process.
The most strange thing is that executing the same command for the
database we used in IXPMv5.8 operates fine. <br>
</p>
<p>Just to mention that before the upgrade backing up our database
didn't provide any issues.</p>
<p>Do you have any ideas since this issue doesn't allow us to
correctly back up our database.</p>
<p>P.S.</p>
<p>Server version: 8.0.27 MySQL Community Server - GPL<br>
</p>
<p>Kind Regards,</p>
<p>Marinos<br>
</p>
<br>
<br>
</body>
</html>