Backup database over SFTP

backup.ps1

$server = "your.sftp.server.com"
$user = "yoursftpuser"
$database = "databasename"

$datetime = Get-Date -Format "yyyyMMddHHmmssffff"
$filename = "$($database)_$($datetime)"
$sqlFile = "$($filename).sql"
$tarFile = "$($filename).tar.gz"

mysqldump $database > $sqlFile
tar -czf $tarFile $sqlFile

Write-Output "put $($tarFile)" | sshpass -f "sftp_pass" sftp $user@$server

Remove-Item $sqlFile
Remove-Item $tarFile