Differences
This shows you the differences between the selected revisions of the page.
| 2012-01-13 | 2012-01-13 | ||
| syntax (martin) (hidden) | Restored revision 1326190421. Undoing revisions 1326444110, 1326444132. (martin) (hidden) | ||
| Line 30: | Line 30: | ||
| The command must not require user input. | The command must not require user input. | ||
| - | |||
| - | ===== Example ===== | ||
| - | <code csharp> | ||
| - | using System; | ||
| - | using WinSCP; | ||
| - | |||
| - | class Example | ||
| - | { | ||
| - | public static int Main() | ||
| - | { | ||
| - | try | ||
| - | { | ||
| - | // Setup session options | ||
| - | SessionOptions sessionOptions = new SessionOptions(); | ||
| - | sessionOptions.Protocol = Protocol.Sftp; | ||
| - | sessionOptions.HostName = "example.com"; | ||
| - | sessionOptions.UserName = "user"; | ||
| - | sessionOptions.Password = "mypassword"; | ||
| - | sessionOptions.SshHostKey = "ssh-rsa 1024 xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx:xx"; | ||
| - | |||
| - | using (Session session = new Session()) | ||
| - | { | ||
| - | // Connect | ||
| - | session.Open(sessionOptions); | ||
| - | |||
| - | // Execute mysqldump on the server to dump all MySQL databases and compress the results | ||
| - | const string dbUsername = "USERNAME"; | ||
| - | const string dbPassword = "PASSWORD"; | ||
| - | const string tempFilePath = "/tmp/all_databases.gz"; | ||
| - | |||
| - | string dumpCommand = | ||
| - | 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(); | ||
| - | } | ||
| - | |||
| - | return 0; | ||
| - | } | ||
| - | catch (Exception e) | ||
| - | { | ||
| - | Console.WriteLine("Error: {0}", e); | ||
| - | return 1; | ||
| - | } | ||
| - | } | ||
| - | } | ||
| - | </code csharp> | ||