Solved

Connecting and restoring a mysql dump to an rds instance in amazon aws

Posted on 2016-09-07
4
34 Views
Last Modified: 2016-09-14
Hi,

I have an RDS instance and i can connect it via ssh but i need to restore a mysql backup on my local machine.

I cannot find a way how to this with mysql workbench or sql yog.

As a starter, i don't see an ip but a dns which i couldn't use.

Please help.

Br.
0
Comment
Question by:jazzIIIlove
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
  • 2
4 Comments
 
LVL 57

Expert Comment

by:Julian Hansen
ID: 41791605
Have you tried creating an SSH tunnel through SQLYog to the database?
0
 
LVL 12

Accepted Solution

by:
jazzIIIlove earned 0 total points
ID: 41792041
Yes. Ok. I solved by creating another ec2 instance and used sqlyog in that instance instead of my local machine.
0
 
LVL 57

Expert Comment

by:Julian Hansen
ID: 41792266
Good - for reference though you can run SQLYog over an SSH link. If you have the enterprise version in your connection settings there is the option to do port mapping over SSH. You connect with SSH (Putty or whatever) and you connect through that. Works seemlessly. I have never done it to an AWS instance but I will be shortly as we are starting a big AWS project this month.
0
 
LVL 12

Author Closing Comment

by:jazzIIIlove
ID: 41797517
Yes. Ok. I solved by creating another ec2 instance and used sqlyog in that instance instead of my local machine.
0

Featured Post

Save the day with this special offer from ATEN!

Save 30% on the CV211 using promo code EXPERTS30 now through April 30th. The ATEN CV211 connects a laptop directly to any server allowing you instant access to perform data maintenance and local operations, for quick troubleshooting, updating, service and repair.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In the wake of AWS' S3 outage, we want to discuss the importance of storage and data diversification in the event of a hack, crash, or system disruption. We spoke with Experts Exchange’s COO Gene Richardson for a deeper understanding.
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Connecting to an Amazon Linux EC2 Instance from Windows Using PuTTY.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

752 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question