MySQL Forums
Forum List  »  Backup

Getting error while restoring from back up file with Views, Triggers
Posted by: Sagar Malpani
Date: September 19, 2022 11:42PM

I'm took the backup of the Sakila database created in the azure cloud and it has some views and triggers as well. While trying to restore that database with other user (non root and with non super privilege's) but getting error on the definer statements as it is having the username that has took the backup in the backup file and other user is not having the access to execute those statements.

Options: ReplyQuote


Subject
Views
Written By
Posted
Getting error while restoring from back up file with Views, Triggers
97
September 19, 2022 11:42PM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.