Bug #102927 Dump and Load users, roles and grants only
Submitted: 11 Mar 2021 13:58
Reporter: Frederic Descamps Email Updates:
Status: Verified Impact on me:
Category:Shell Dump & Load Severity:S4 (Feature request)
Version:8.0 OS:Any
Assigned to: CPU Architecture:Any

[11 Mar 2021 13:58] Frederic Descamps
MySQL Shell Dump & Load utility are great.

However, I see more and more people asking to migrate only Users/Roles and Grants from a server to another.

And of course to OCI too.

The Dump & Load Utility seem to already have all what's needed to perform this (dump users with include or exclude, ocimds mode, ...) but for the moment it seems also  impossible to dump and load only users. Data or at least schema definition must be used.

How to repeat:
This is a feature request.

Suggested fix:
add the possibility to only dump and load users (with or without ocimds compatibility of course)