Migrating MySQL User Data When Running Database Migration Service Jobs

In this Project, you will:

Identify existing MySQL users on the source instance. Update DEFINER clauses to INVOKER on the MySQL source instance.

Create and save a Database Migration Service job without starting the job.

Create users on the Cloud SQL destination instance. Start a previously created Database Migration Service job.

Check user metadata in the Cloud SQL destination instance.

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

In Projects, you'll complete an activity or scenario by following a set of instructions in an interactive hands-on environment. Projects are completed in a real cloud environment and within real instances of various products as opposed to a simulation or demo environment.

By purchasing a Project, you'll get everything you need to complete the Project including temporary access to any product required to complete the Project.

Even though Projects are technically available on mobile devices, we highly recommend that you complete Projects on a laptop or desktop only.

Yes, you can download and keep any of your created files from the Project. To do so, please make sure you save any files and work to your device before exiting the product environment.

Projects are not eligible for refunds. See our full refund policy.

Financial aid is not available for Projects.

In rare instances, Projects may be taken down for maintenance or other reasons. If you are experiencing any issues, please contact us.

Auditing is not available for Projects.

At the top of the page, you can view the experience level recommended for this Project.

Yes, everything you need to complete your Project will be available in your browser.