Migrating MySQL User Data When Running Database Migration Service Jobs

In this Project, you will:
1.5 hours
Advanced
No download needed
Shareable certificate
English
Desktop only

This is a self-paced lab that takes place in the Google Cloud console. In this lab, you learn how to migrate MySQL user data when running Database Migration Service jobs. First, you identify the existing MySQL users and update DEFINER to INVOKER for database objects on the source instance. Next, you create and save a Database Migration Service job. Then, before running the migration job, you create the necessary users on the destination database instance. Finally, you start the saved migration job; after the job runs successfully, you check the migrated data in the Cloud SQL for MySQL instance.

Skills you will develop

  • Database (DBMS)

  • Metadata

  • MySQL

How Projects work

Learn a new tool or skill in an interactive, hands-on environment

You'll gain access to software and tools in a cloud workspace - no download required

Offered by

Placeholder

Google Cloud

Frequently Asked Questions