Solved

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

Posted on 2016-09-07
4
30 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 52

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 52

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

Network it in WD Red

There's an industry-leading WD Red drive for every compatible NAS system to help fulfill your data storage needs. With drives up to 8TB, WD Red offers a wide array of solutions for customers looking to build the biggest, best-performing NAS storage solution.  

Question has a verified solution.

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

I recently attended Cisco Live! in Las Vegas, a conference that boasted over 28,000 techies in attendance, and a week of hands-on learning hosted by a solid partner with which Concerto goes to market.  Every year, Cisco displays cutting-edge technol…
Introduction This article is intended for those who are new to PHP error handling (https://www.experts-exchange.com/articles/11769/And-by-the-way-I-am-New-to-PHP.html).  It addresses one of the most common problems that plague beginning PHP develop…
Steps to create a PostgreSQL RDS instance in the Amazon cloud. We will cover some of the default settings and show how to connect to the instance once it is up and running.
Both in life and business – not all partnerships are created equal. As the demand for cloud services increases, so do the number of self-proclaimed cloud partners. Asking the right questions up front in the partnership, will enable both parties …

896 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now