When you migrate to MySQL Database Service on Oracle Cloud Infrastructure (MDS on OCI), the easiest, fastest and recommended way it to use MySQL Dump & Load Utility.
For more information check these different links:
- https://mysqlserverteam.com/mysql-shell-dump-load-part-1-demo/
- https://mysqlserverteam.com/mysql-shell-dump-load-part-2-benchmarks/
- https://mysqlserverteam.com/mysql-shell-dump-load-part-3-load-dump/
- https://docs.oracle.com/en-us/iaas/mysql-database/doc/importing-and-exporting-databases.html
- http://dasini.net/blog/2020/12/17/mysql-shell-the-new-era/
- https://blogs.oracle.com/mysql/migrate-from-on-premise-mysql-to-mysql-database-service
MySQL Shell performs all the checks required also for copying users to MDS when using util.dumpInstance()method.
This is the safest way to migrate data to MDS as when the ocimds option is enabled, you have the possibility to skip accounts which use authentication methods (plugins) not supported by the MySQL Database Service but also to remove certain privileges that are restricted in the MySQL Database Service.
But sometimes you may only want to copy a user (or some) to one server to another one. And that destination server can also be a MDS instance.
Therefore, I’ve added a new method the the user plugin for MySQL Shell available on GitHub.
If you are interested, this is how it works:
[…] as I already wrote on this previous post, MySQL Shell Plugins can help for this […]