I want to connect to a remote server which I have a mySQL DB on, and do a mysqldump so I have a backup. I will likely schedule this with CRON to run every night.
However, to make any changes to the mySQL server I have to SSH onto it, binding my local mySQL port to the remote one.
Is this possible to do in a shell script?
I would normally connect using a command in the format:
So my main question is can I issue the password in the shell script? I know that this would leave it vulnerable as the password would be un-encrypted in the script but for the moment I'm not worried about that.
The other alternative is to do the mysql dump on the sever itself, and then have a script on my backup server to retrieve the backup file using FTP, but I'd rather not do this is possible.
Location: Asia Pacific, Cyberspace, in the Dark Dystopia
Posts: 19,118
Thanks Given: 2,351
Thanked 3,359 Times in 1,878 Posts
One way to do this is to set up an SSH key pair (without a password) between your two servers. This will permit you to SSH between servers in a secure manner using the crypto key pairs, without a password. Many folks do this.
Hi,
I am totally a newbie to any programming languages and I just started an entry level job in an IT company. One of my recent tasks is to create a script that is able to show the log file of linux service (i.e. ntpd service)
lets say, if I run my script ./test.sh, the output should be... (3 Replies)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Dear Unix gurus,
We have a config shell script file which has 30 variables which needs to be passed to master unix shell script that invokes oracle database sessions. So those 30 variables need to go through the database sessions (They are inputs) via a shell script. one of the variable name... (1 Reply)
Hi,
Apologies if this belongs in the beginner area.
So.. The server I need to log into only allows logins from certain IP addresses. One of those IP's is my home computer, I can easily ssh into my home computer from elsewhere, and would then try to login to my work computer from there, but it... (1 Reply)
I have a shell script (.sh) and I want to pass a parameter value to the awk command but I am getting exception, please assist.
diff=$1$2.diff
id=$2 new=new_$diff
echo "My id is $1"
echo "I want to sync for user account $id"
##awk command I am using is as below
cat $diff | awk... (2 Replies)
Hi All,
I have new for shell scripting.
Problem : I have one scrip at serv1 and path of server is /apps/dev/provimage/scripts and script name:extract_ancillary.bat.
I need to call this script at server2(my working server) and execute at server2 .
Please let me know how to build the... (5 Replies)
ssh $USR@$host /bin/bash <<EOF
awk ' BEGIN{f=0} !f { s=$0; sub(/,.+/, "", s); gsub(//, " ", s); t=(systime()-mktime(s)); if(t<=14400) f=1 } f ' /home/error.log >> error.txt
EOFWe are trying to connect to a remote server through ssh and read values from error.log within last 4 hours.However, the... (3 Replies)
i want use ssh on the host01 to execute autoexec.sh on the host02 like following :
host01> ssh host02 autoexec.sh
autoexec.sh include nohup command like follwing :
nohup /home/jack/deletedata.sh &
after i execute ssh host02 autoexec.sh one the host01. i can't found deletedata.sh... (1 Reply)
Hi,
I have got a shell script, which fails to run properly..
I am getting the following error:
"Pseudo-terminal will not be allocated because stdin is not a terminal.
Permission denied (gssapi-keyex,gssapi-with-mic,publickey,keyboard-interactive)."
I SSH to the machine and then run the... (1 Reply)
I have the following block from a script (it's not the entire script, but I'm confident it's all that is pertinent)
echo "$SESSIONS"|while read ID;do
ASSETID=$(echo "$ERRORS"|grep -i "$ID"|grep FX_Media_Session_Playlist::init_playlist|grep -i asset_id=|awk '{print $11}')
BLADE=$(echo... (2 Replies)
