Solved

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

Posted on 2016-09-07
4
32 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
  • 2
  • 2
4 Comments
 
LVL 55

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 55

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

Best Practices: Disaster Recovery Testing

Besides backup, any IT division should have a disaster recovery plan. You will find a few tips below relating to the development of such a plan and to what issues one should pay special attention in the course of backup planning.

Question has a verified solution.

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

There is no doubt that cloud is gaining importance. Many of you must have read about this technology and its growing importance. More and more organisations are embracing this technology not forgetting start-ups. The process begins by dipping …
Learn how the use of a bunch of disparate tools requiring a lot of manual attention led to a series of unfortunate backup events for one company.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Concerto provides fully managed cloud services and the expertise to provide an easy and reliable route to the cloud. Our best-in-class solutions help you address the toughest IT challenges, find new efficiencies and deliver the best application expe…

820 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