Restoring Backup From mysqldump does not Recreate All Views + Error 1449 + SQLState HY000 + The User Specified as a Definer does not Exist
(Doc ID 1365866.1)
Last updated on SEPTEMBER 08, 2021
Applies to:
MySQL Server - Version 5.0 and later Information in this document applies to any platform.
Symptoms
When attempting to load the dump of all databases from mysqldump into a freshly installed MySQL instance, the following error occurs.
Changes
Cause
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!