CODEWITHSUNDEEP
mysqlamazon-web-servicesrds
CaptainStiggz
CaptainStiggz

Reputation: 1907

Create local copy of Amazon RDS Database

How do I mysqldump the database on my AWS RDS instance to a .sql file for local use?

Upvotes: 7

Views: 4932

Answers (2)

foxybagga
foxybagga

Reputation: 4214

Or you can use a client like MySQL Work Bench to open it remotely and export it to .sql anytime you feel like.

http://www.mysql.com/products/workbench/

Upvotes: 1

Christopher
Christopher

Reputation: 44284

This is easy:

mysqldump -H <RDS_URL> -u <user> -p<password> <db> > myfile.sql

As long as you add the -H with proper user / password credentials, you'll have no problem.

Upvotes: 9

Related Questions