Home / server / Questions / 401038
In Process
David542
Asked: 2012-06-22 10:12:07 +0800 CST

Using port forwarding to log into remote mysql server

  • 772

I would like to import a local file into my remote mysql database, which is residing on ec2. How would I accomplish the following:

$ ssh -i ~/.ssh/my_key.pem user@ip
$ mysql -u root localhost [ remote database ] < ~/dump.sql [ local file ]

Is there a way to do this with -L? How would I do this with one command here?

mysql ssh port-forwarding

1 Answers

  1. cat ~/dump.sql | ssh -i ~/.ssh/my_key.pem user@ip mysql -u root [ remote database ]
    • 2