Script to copy a file remotely using winscp
Create a shell script and copy the below code to the file. Later you can run this script to execute the commands automatically
#command to connect to the remote server using winscp
winscp sftp://username:password@serveripordomain/ -rawsettings SendBuf=0
#tar and zip a folder before copying it. use --exclude to exclude files
call tar -czf archive15dec2022.tar.gz /path/to/folder/youwanttocopy
#get the file to your local pc/server and deleting it from the remote server
get -delete archive15dec2022.tar.gz
#below command to remotely zip a mysql database and get the sql file
call mysqldump -umysqluser -pmysqlpassword dbname > archive15dec2022.sql
get -delete archive15dec2022.sql
exit