Copy a file from your local computer to a remote host using secure copy, scp (which uses ssh for data transfer and provides the same security as using ssh).
scp [filename] [username]@remotehost:[location]
scp file_to_copy.txt username@example.net:/some/remote/directory
copy a directory to your home computer from the remote computer.
scp -r directory_to_copy username@example.net:
copy a directory from a remote server to the current directory on your computer.
scp -r folder [username]@remotehost:[location] .
scp -r username@example.net:/some/remote/directory .
If you don’t have automated keys setup you will be asked for the password for that user.
An example for copying a MySQL database. Including the : without a location puts the file in the home folder.
mysqldump database_name -uroot > database_dump.sql scp database_dump.sql user@example.net:
Then ssh into the remote server and open the mysql prompt
mysql -uroot -p mysql> create database database_name; mysql> exit
Then run the mysqldump file
mysql database_name -uuser -p < database_dump.sql
Remember to create the database user on the new machine (this has to match what is in the wp-config.php file).
Pingback: Rsync to copy Files Between Servers and Computers | Coding and Server Syntax Examples
Pingback: Chrome Remote Desktop | Coding and Server Syntax Examples