I am implementing an automated backup scheme so I created a shell script which first creates
SQL Dumps for all MySQL databases, then it retrieves all the websites from the /var/www of a remote
server. The latter is working as I am using rsync to get the remote files.
However, obviously, the MySQL dumps being retrieved are the ones on the local
server which is not what I want. I want to get the
SQL Dumps from the remote
server as well.
I have a tunnel between the local and remote
server which I can connect without using any password (I added the public key to the authorized_hosts), so I tried to add the following code to the script:
ssh
[email protected]
Then I tried to retrieve the
SQL dumps and then I exit from the remote
server. However this does not work as I still have to enter exit manually in the terminal for the
SQL dumps to be retrieved from the remote host. I don't know why this is happening. Basically this is what the script is trying to do:
//connect to remote
server
ssh
[email protected]
//retrieve
SQL dumps
//code to retrieve...
//exit from remote
server
exit
//use rsync to get remote files of /var/www from local
server (working)
Is there a way to connect to the remote host AND run the script's code ON THAT remote host?
Many thanks in advance
