[MDEV-24380] mysqldump can't dump mysql.user table ? Created: 2020-12-09 Updated: 2020-12-10 Resolved: 2020-12-09 |
|
| Status: | Closed |
| Project: | MariaDB Server |
| Component/s: | N/A |
| Affects Version/s: | None |
| Fix Version/s: | N/A |
| Type: | Bug | Priority: | Major |
| Reporter: | naox | Assignee: | Unassigned |
| Resolution: | Not a Bug | Votes: | 0 |
| Labels: | None | ||
| Description |
|
invalid. How to delete? |
| Comments |
| Comment by Elena Stepanova [ 2020-12-09 ] |
|
mysql.user is not a table anymore, it is a view, so it doesn't have contents of its own; and due to -t option its structure isn't dumped either, thus the call is void. |
| Comment by Daniel Black [ 2020-12-09 ] |
|
mysql.user is a view from 10.4 onwards. |
| Comment by Daniel Black [ 2020-12-10 ] |
|
Note next release will have `mysqldump --system=users` to dump all their users and grants in SQL form (`CREATE USER ./ROLE`, `GRANT` ...). ( |