Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

[BUG] Can not restore database into RDS #435

Closed
speller opened this issue Oct 12, 2021 · 2 comments · Fixed by #553
Closed

[BUG] Can not restore database into RDS #435

speller opened this issue Oct 12, 2021 · 2 comments · Fixed by #553

Comments

@speller
Copy link

speller commented Oct 12, 2021

I have a big local database that I want to migrate to RDS. I dumped it well. But when I restore it, I'm getting the following error:

** (myloader:8262): CRITICAL **: 03:48:14.327: Error restoring ***.*** from file ****-schema-view.sql.gz: Access denied; you need (at least one of) the SUPER privilege(s) for this operation
CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW `***` AS (select `soi`.`ID` ... group by `soi`.`ID`);

A CLI key to strip the DEFINER=root@localhost part should be enough for successful import.

@davidducos
Copy link
Member

We can add the view to the list that @matthewlenz reported in #378

@davidducos davidducos added this to the Release 0.11.3 milestone Oct 12, 2021
@davidducos davidducos linked a pull request Jan 24, 2022 that will close this issue
@davidducos
Copy link
Member

@speller I'm going to close this as the --skip-definer option has been already added to main and will be release on v0.12.1

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Projects
None yet
Development

Successfully merging a pull request may close this issue.

2 participants