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

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.
LVL 12
jazzIIIloveAsked:
Who is Participating?
 
jazzIIIloveAuthor Commented:
Yes. Ok. I solved by creating another ec2 instance and used sqlyog in that instance instead of my local machine.
0
 
Julian HansenCommented:
Have you tried creating an SSH tunnel through SQLYog to the database?
0
 
Julian HansenCommented:
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
 
jazzIIIloveAuthor Commented:
Yes. Ok. I solved by creating another ec2 instance and used sqlyog in that instance instead of my local machine.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.