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

Jump to bottom

Allow simplifying exported view syntax to only "CREATE VIEW" #14815

Closed
thinsoldier opened this issue Dec 24, 2018 · 5 comments · Fixed by #15416
Closed

Allow simplifying exported view syntax to only "CREATE VIEW" #14815

thinsoldier opened this issue Dec 24, 2018 · 5 comments · Fixed by #15416
Assignees
@williamdes
Labels
enhancement A feature request for improving phpMyAdmin has-pr An issue that has a pull request pending that may fix this issue. The pull request may be incomplete
Projects
Enhancements
Milestone
5.1.0

Comments

@thinsoldier
Copy link

thinsoldier commented Dec 24, 2018 •
edited by williamdes

Is your feature request related to a problem? Please describe.

Very often when I export a database from one server to move it to another server the views have the error message: #1227 - Access denied; you need (at least one of) the SUPER privilege(s) for this operation Or another message about the user mentioned in the exported view code not existing on the new server.

Describe the solution you'd like

I'd like a checkbox in the export options that says "Use simple View export" that replaces this:

CREATE ALGORITHM=UNDEFINED DEFINER=`root`@`localhost` SQL SECURITY DEFINER VIEW...

with this

CREATE VIEW...

Additional context

  • phpMyAdmin version: 4.2.11 and 4.8.3
@williamdes williamdes added the enhancement A feature request for improving phpMyAdmin label Dec 24, 2018
@bahl24
Copy link
Contributor

bahl24 commented Jan 29, 2019

@williamdes @ibennetch Is this feature desired? If yes, can I start working on it?

@williamdes
Copy link
Member

@bahl24 I personally agree with this request :)

@bahl24
Copy link
Contributor

bahl24 commented Feb 23, 2019

@williamdes I am not able to understand where to put the checkbox, should I put it alongside
screenshot from 2019-02-24 01-51-02
or elsewhere as this is regarding exporting a db and not individual view.

@williamdes
Copy link
Member

@bahl24 In the data creation option area ?

@bahl24
Copy link
Contributor

bahl24 commented Feb 25, 2019

@williamdes I was thinking maybe in object creation system

@kartik1000 kartik1000 mentioned this issue Aug 5, 2019
Merged
6 tasks
@williamdes williamdes added the has-pr An issue that has a pull request pending that may fix this issue. The pull request may be incomplete label Aug 20, 2019
@williamdes williamdes self-assigned this Jan 9, 2020
@williamdes williamdes added this to the 5.1.0 milestone Jan 9, 2020
@williamdes williamdes added this to Triage zone in Enhancements Jan 23, 2020
@williamdes williamdes moved this from Triage zone to Nice to have soon in Enhancements Jan 23, 2020
@kartik1000 kartik1000 mentioned this issue Mar 20, 2020
Closed
williamdes added a commit that referenced this issue May 1, 2020
@williamdes
Merge #15416 - Fix #14815 - Allow simplifying exported view syntax to…
a09a63f 
… only "CREATE VIEW"

Merge #15416
Fixes: #14815

Signed-off-by: William Desportes <williamdes@wdes.fr>
williamdes added a commit that referenced this issue May 1, 2020
@williamdes
Add a ChangeLog entry for #14815
4853443 
Signed-off-by: William Desportes <williamdes@wdes.fr>
Enhancements automation moved this from Nice to have soon to Done May 1, 2020
@github-actions github-actions bot locked as resolved and limited conversation to collaborators May 2, 2021
Sign up for free to subscribe to this conversation on GitHub. Already have an account? Sign in.
Assignees

@williamdes williamdes

Labels
enhancement A feature request for improving phpMyAdmin has-pr An issue that has a pull request pending that may fix this issue. The pull request may be incomplete
Projects
Enhancements
  
Done
Milestone
5.1.0
Development

Successfully merging a pull request may close this issue.

Export view option added in Export kartik1000/phpmyadmin
3 participants
@thinsoldier @williamdes @bahl24