AMAZON RELATIONAL DATABASE SERVICE (RDS)

About RDS

Amazon RDS is a web service to set up, operate, and scale a relational database in the cloud. It provides cost-efficient, re-sizable capacity for a relational database and manages common database administration tasks.

 

Importing database into RDS

To import a database on RDS use the following command:

#mysql -h [host-name] -u [user-name] -p[password] dbname < backupdb.sql

-h: specify the rds hostname here

-u: specify the rds username

-p: Enter password for rds user

 

Exporting database from RDS

To export database from rds use the following command

#mysqldump -h [host-name] -u [user-name] -p[password] dbname > backupdb.sql

-h: specify the rds hostname here

-u: specify the rds username

-p: Enter password for rds user

That’s all!

Leave a Reply

Your email address will not be published. Required fields are marked *