I’m exporting database from Magento 2.4.2 with this command:
mysqldump --single-transaction DBUSER --triggers | sed -e 's/DEFINER[ ]*=[ ]*[^*]**/*/' | gzip > FILENAME.`date +"%Y%m%d"`.sql.gz
I get this error:
mysqldump: Couldn’t execute ‘SHOW FIELDS FROM
inventory_stock_1
‘:
View ‘DBNAME.inventory_stock_1’ references invalid table(s) or
column(s) or function(s) or definer/invoker of view lack rights to use
them (1356)