0

I am currently using Amazon Lighsail for my Wordpress site. I have a fresh Wordpress install on my Lightsail account but would like to upload my old mysql tables from my current site to phpmyadmin.

I have ssh-ed into the terminal and have done cd apps/phpmyadmin/ but I am not seeing my wp_ tables that I need to replace. How do I access this?

I tried the following command to do ssh port forwarding but it didnt work: ssh bitnami@xx.xxx.xx.xxx -R 8080:127.0.0.1:80 (with the x's being real numbers)

Any idea on how I can upload my current .sql.zip file to Wordpress AWS Lighsail using SSH?

Thanks in advance!

a2b123
  • 573
  • 1
  • 5
  • 19
  • Your creating an SSH tunnel to send web traffic through. You create a tunnel in your terminal, then Open a web browser and point it at `http://127.0.0.1:8080/phpmyadmin` – MisterSmith Apr 10 '18 at 21:57
  • that's what I am trying to do by porting it forward @MisterSmith. Right now when I go to `http://127.0.0.1:8080/phpmyadmin` i get DNS error despite having my AWS VM running – a2b123 Apr 10 '18 at 22:01
  • Have you confirmed if phpmyadmin is actually running/available from the server? Login to server with SSH and run `netstat -tln` to view listening ports - 127.0.0.1:80 should appear in the list? If so, use `curl http://127.0.0.1:80/phpmyadmin` to make a web request from the terminal - you will get the HTML page or a connection failed. This will prove everything is working remotely. (If it deosnt work try ports 8080 and 8888 as well) can you post any output/error from ssh command? (enable verbose output with `-v`). – MisterSmith Apr 10 '18 at 23:29

0 Answers0