Differences

This shows you the differences between the selected revisions of the page.

2012-03-26		2012-04-03
vb.net signature (martin)		vbnet example (martin)
	Line 84:		Line 84:
	}		}
	}		}
		+	</code>
		+
		+	==== [[vbnet]] VB.NET Example ====
		+	<code vbnet>
		+	Imports System
		+	Imports WinSCP
		+
		+	Friend Class Example
		+
		+	Public Shared Function Main() As Integer
		+
		+	Try
		+	' Setup session options
		+	Dim sessionOptions As New SessionOptions;
		+	With sessionOptions
		+	.Protocol = Protocol.Sftp
		+	.HostName = "example.com"
		+	.UserName = "user"
		+	.Password = "mypassword"
		+	.SshHostKey = "ssh-rsa 1024 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx"
		+	End With
		+
		+	Using session As Session = New Session
		+	' Connect
		+	session.Open(sessionOptions)
		+
		+	' Execute mysqldump on the server to dump all MySQL databases and compress the results
		+	Const dbUsername As String = "USERNAME"
		+	Const dbPassword As String = "PASSWORD"
		+	Const tempFilePath As String = "/tmp/all_databases.gz"
		+
		+	' Execute mysqldump on the server to dump all MySQL databases and compress the results
		+	Dim dumpCommand As String = _
		+	String.Format("mysqldump --opt -u {0} --password={1} --all-databases \| gzip > {2}", _
		+	dbUsername, dbPassword, tempFilePath)
		+	session.ExecuteCommand(dumpCommand)
		+
		+	' Download the database dump
		+	session.GetFiles(tempFilePath, "D:\dbbackup\").Check
		+	End Using
		+
		+	Return 0
		+	Catch e As Exception
		+	Console.WriteLine("Error: {0}", e)
		+	Return 1
		+	End Try
		+
		+	End Function
		+
		+	End Class
	</code>		</code>

Documentation