You can call mysqldump, a MySql tool.
Class Cmd to call the cmd command,
The Directory of the process to be started is the directory of mysql's automatic backup and restoration database tool mysqldump and mysql. Of course, this method can execute other command line tools.
Using System;
Using System. Collections. Generic;
Using System. Text;
Using System. Diagnostics;
Public class Cmd
{
/// <Summary>
/// Execute the Cmd command
/// </Summary>
/// <Param name = "workingDirectory"> directory of the process to be started </param>
/// <Param name = "command"> command to be executed </param>
Public static void StartCmd (String workingDirectory, String command)
{
Process p = new Process ();
P. StartInfo. FileName = "cmd.exe ";
P. StartInfo. WorkingDirectory = workingDirectory;
P. StartInfo. UseShellExecute = false;
P. StartInfo. RedirectStandardInput = true;
P. StartInfo. RedirectStandardOutput = true;
P. StartInfo. RedirectStandardError = true;
P. StartInfo. CreateNoWindow = true;
P. Start ();
P. StandardInput. WriteLine (command );
P. StandardInput. WriteLine ("exit ");
}
}
Backup method:
Using System;
Using System. Collections. Generic;
Using System. ComponentModel;
Using System. Data;
Using System. Drawing;
Using System. Text;
Using System. Windows. Forms;
Using System. IO;
Using System. Diagnostics;
Using System. Configuration;
Using MDRClient. DataAccess;
Namespace MDRClient
{
Public partial class DataBackup: Form
{
Public DataBackup ()
{
InitializeComponent ();
}
Private
