spektrasystems / azure-mysql-dms-lab Goto Github PK

1. Exercise 1 and 2 - Look for module 1 review

2. mysqldump -h 52.167.5.121 -u root -p --databases sakila > C:\DMS\sakila-mv-data.sql < Change this to localhost from IP

3. mysql.exe -h mydemoservernm.mysql.database.azure.com -u myadmin@mydemoservernm -p sakila > C:\DMS\sakila-mv-data.sql >> don't use .exe. keep same everywhere.

4. mysqldump -h 52.167.5.121 -u root -p --databases sakila > C:\DMS\sakila-mv-data.sql >> this is wrong. we need to add --no-data to command and --database. for example
   mysqldump -h localhost -u root -p --databases sakila --no-data > C:\DMS\sakila-mv-data.sql

5. import schema, it needs to be < instead of >

6. Source server name: localhost under migration task craete - this can not be localhost. this has to be DNS name of the DMS-DeV VM

7. Show cutover step and cutover completed

1. As soon as we login, show both RG screenshot and give their description

2. Please ensure to enter a unique name for storage account name and share name. >> highlight unique name, storage account name, share name with bold

3. az mysql server create --resource-group --sku-name GP_Gen5_8 --name --location --admin-user mysqlAdminUser --admin-password 'mysqlAdminPassw0rd!' --ssl-enforcement Disabled --storage-size 51200 << Change password to 'Password!1234'

4. When creating mysql server, it kept on running forever for me. Had to create using Portal

4.az webapp deployment user set --user-name "username" --password gitDeployPassw0rd! >> The publishing username has to be globally unique, and the name you provided has already been taken by another Azure customer. Please type in a different name. >> Tell this

5. git remote add website > ask them to copy URL from output of az web app create "deploymentLocalGitUrl": "https://[email protected]/mysqlamit12.git",

6.Open the web site.
14. The website should be up and running. >> show how to open website and sucessful page

7. Include instruction after creating MySQL Server that ensure SSL is disabled.