[ubuntu] WinSCP Backup Script Issue

[FN-GM]

Hi,

 

I am using the below backup script in Windows to backup MySQL on an Ubuntu server. I keep getting permission denied

 

"X:\winscp550\WinSCP.exe" /console /command "open scp://user:[email protected]:22" "synchronize local -criteria=either X:\Backup-Script\Webserver\MySQL /var/lib/automysqlbackup" "exit"

 

To resolve this should I alter the permissions on the Ubuntu server or somehow run the WinSCP as sudo? What command for these would I use please?

 

Thanks

Edited April 18, 2016 by FN-GM

[FN-GM]

Anyone please?

[mats]

I've never used winscp from the command line so I'm flying blind a little here.

 

Try scp from the linux command line to verify that you can copy the file sucessfully with your user & password.

 

Is /var/lib/automysqlbackup a file or directory? Should be ok with a file, if it's a directory I'm not sure if it'll work like that - check for recursive options.