Amazon Web Services Question posted in
The official Amazon Web Services documentation can be found here.

Amazon web services – Restore an AWS db from one server to another

I have two different AWS servers for RDS instances.

I want to restore db from one server to another, but can’t since the backup is created on another server(which it belongs to).

What is the best way to do this?
So far, I have created the backup and am trying to copy it in my local using scp command like this :

scp <username>@<servername>:"/D:/rdsdbdata/BACKUP/filename.bak" -U <username> -P <pass> "D:/"

but to no avail.

Tags:

2

Answers


  1. 0

    To move a database from one AWS server to another, you need to start by backing it up. Once that’s done, grab the backup file from the original server using the scp command. Fix your scp command like this:

    scp -P <port> <username>@<servername>:"/D:/rdsdbdata/BACKUP/filename.bak" "D:/"

    Replace port, username, servername, and <filename.bak> with the right stuff. After getting the backup to your local machine, use the AWS RDS tools to restore it onto the new server. Just make sure the destination server is set up correctly for the restore. Keep it simple, and you should be good to go!

    Login or Signup to reply.
  2. 0

    To ‘backup’ an Amazon RDS database, you can create a Snapshot. This copies the complete contents of the database instance.

    The snapshot is kept within the Amazon RDS service — there is no need to download or save the snapshot.

    You can then launch a new Amazon RDS instance from the snapshot. The new RDS instance will contain all data that was saved in the Snapshot. Please note that you must create a new RDS instance from the snapshot — you do not copy or load the data into an existing RDS instance.

    See: Working with backups – Amazon Relational Database Service

    Login or Signup to reply.
Please signup or login to give your own answer.

Back To Top
Search