Search 6,000+ CA Community College Courses

Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

Google

Migrating MySQL User Data When Running Database Migration Service Jobs

Google via Google Cloud Skills Boost

Go to class Write review

Overview

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.

Syllabus

  • Overview
  • Objectives
  • Setup
  • Task 1. Identify the existing MySQL users on the source instance
  • Task 2. Update DEFINER to INVOKER on the MySQL source instance
  • Task 3. Create and save a Database Migration Service job without starting it
  • Task 4. Create the necessary users on the Cloud SQL destination instance
  • Task 5. Run a previously created migration job
  • Task 6. Confirm the user metadata in Cloud SQL for MySQL
  • End your lab

Tags

Reviews

Start your review of Migrating MySQL User Data When Running Database Migration Service Jobs

Go to class

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.