[MDEV-13117] mysqldump to support --skip-definer Created: 2017-06-17 Updated: 2022-10-06 |
|
| Status: | Open |
| Project: | MariaDB Server |
| Component/s: | None |
| Fix Version/s: | None |
| Type: | Task | Priority: | Major |
| Reporter: | VAROQUI Stephane | Assignee: | Unassigned |
| Resolution: | Unresolved | Votes: | 6 |
| Labels: | None | ||
| Issue Links: |
|
||||||||
| Description |
|
5.7 compatibility issue and intresting feature |
| Comments |
| Comment by Rai An [ 2019-12-09 ] |
|
mysqldump needs a parameter --skip-definer |
| Comment by Irwanto Irwanto [ 2020-11-13 ] |
|
i didn't find mysqlpump too in 10.0 and later |
| Comment by John Gwinner [ 2022-10-06 ] |
|
This is a killer for us - none of our production databases can be restored without hand-editing the resulting .sql dumped file. It's odd as tables that are created by the same user aren't marked with a definer, yet all views seem to be. This is a production issue. We can't apply patches until the patch is verified on a copy of production, and our CI/CD routines can't restore the production database to test the patch. Bad situation. I tried mysqlpump but got an error "Server version is not compatible. Server version should be 5.6.46 or above." We are on Mariadb 10.6.8. |