AWS SAA - Module 5 - Challenge Lab: Migrating a Database to Amazon RDS - Anand K

Module 5 - Challenge Lab: Migrating a Database to Amazon RDS
Lab overview and objectives
In this lab, you will migrate data from a database on an Amazon Elastic Compute Cloud (Amazon EC2) instance to Amazon Relational Database Service (Amazon RDS). Specifically, you will migrate a MariaDB database that runs on an EC2 instance to a MariaDB database that runs on Amazon RDS. You will also update the café web application to use the new database to store data for all future orders.
After completing this lab, you should be able to:
Create an RDS database instance
Export data from MariaDB database by using mysqldump
Connect a SQL client to an RDS database.
Migrate data from a MariaDB database that runs on an EC2 instance to an RDS database instance
Configure a web application to use the new RDS database instance for data storage

[@whiteeagleforce2.040]

sir you are an amazing person and very smart scholar. You helped me a lot thank you sir! Please keep posting and helping us. My professor doest help us and she doesnt care about us. but thank god you are here so please keep posting these videos.

[@anandke]

It's my pleasure

[@kayjay8254]

God Bless you Sir, Amazing videos, Very Helpful, Thank you!

[@dolphineforever]

Hello Sir! I received this ERROR "sh: CafeDbDump.sql: Permission denied" from Step No. 15 : Capture existing data in a file by using the mysqldump utility. mysqldump --databases cafe_db -u root -p > CafeDbDump.sql. Could you please share guidance for solving this issue? Thanks!

[@vanshv6250]

same issue

[@syedgamingyt5985]

broh don't put > sign infront of cafeDbDump

[@tastysquad7]

run this command first cd /home/ec2-user/ this is because after the exit; command you went to a different directory

[@priscillalande8261]

@@tastysquad7tried this command , still having the same issue error 1045 access denied for user root @local host

[@priscillalande8261]

Is anyone getting this error , when running query -mysqldump- database cafe_db -u root -p (error access denied for user ‘root’@local host’ using password

[@mihirpawar2126]

Sir this error in report [Task 6] ERROR. The menu page of the new instance is not displaying correctly. This typically indicates that the Systems Manager parameter store values used by the cafe app are not set correctly. what to do

[@vedangchalke1339]

In parameter , you need to also change '/cafe/db/url ' value

[@JonesDylan874]

Thanks for doing this.

[@heaaro]

you are a legend! thank you, mate,

[@anandke]

Glad it helped

[@kaustubhsonde8654]

I am getting an error which says no such file or directory

[@alexbennett6180]

You are the best!!!!

[@anandke]

tq

[@ZebastianMephisto]

great lab

[@BrothersGame77]

How to fix lab bugs

[@millermcdonell291]

Wonderful!

[@anandke]

Thank you! Cheers!

[@bharatbhojwani4144]

Please tell me how i can get this guided lab

[@ZebastianMephisto]

yo need to registre in aws educate or try cloud quest

[@bharatbhojwani4144]

Sir how I can get your labs or code or guided lab

[@QuantifiedTutorials]

Register with AWS Academy

[@goofyduder2604]

Wise legend

[@anandke]

Thank you

[@TheSnoz1]

thank you mr biryani