Penn State Classifieds>Penn State Online Courses>Migrating MySQL User Data When Running Database Migration Service Jobs

Migrating MySQL User Data When Running Database Migration Service Jobs

About this Course

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.

Created by: Google Cloud


Related Online Courses

In this course, you\'ll learn to install VMware and create a virtual environment with both hacker and target labs. You\'ll master advanced information gathering and reconnaissance in both active... more
This specialization is intended for individuals with a basic understanding of digital technologies as well as developers or security professionals with at least 2 years of programming experience... more
This course will serve as a \"deep dive\" into the concepts and trends related to diversity and inclusion. One of the barriers to sustained organizational effectiveness in this area has been... more
In this 1-hour long project-based course, you will learn how to install Python packages working with Cohere\'s API, integrate external APIs like Cohere in a Python script, use embeddings to analyze... more
e.g. This is primarily aimed at first- and second-year undergraduates interested in engineering or science, along with high school students and professionals with an interest in programming... more

CONTINUE SEARCH

FOLLOW COLLEGE PARENT CENTRAL