SSH connection using PEM file
$ ssh -l ABC.pem username@53.0.111.225

IMPORT mysql db to AWS from local system
$ mysql -u username -h hostname -p dbname < dbfile.sql

EXPORT mysql db
$ mysqldump -h hostname -u username -p db > dbfile.sql

Transfer file via ssh
$ scp -i ABC.pem Source/file.zip username@53.0.111.225:/home/ubuntu/

You may also like

Leave a Reply