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
