Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2016-09-07
4
Medium Priority
?
46 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 59

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 59

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

Will your db performance match your db growth?

In Percona’s white paper “Performance at Scale: Keeping Your Database on Its Toes,” we take a high-level approach to what you need to think about when planning for database scalability.

Question has a verified solution.

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

This article shows how to get a list of available printers for display in a drop-down list, and then to use the selected printer to print an Access report or a Word document filled with Access data, using different syntax as needed for working with …
Considering cloud tradeoffs and determining the right mix for your organization.
Video by: Steve
Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
This is an introductory video for CloudBerry Managed Backup. You will learn how to sign up with the service and get started in a few minutes.

670 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