//perform the CREATE database operation This. Getexecute (G_con,"CREATE database if not exists newdb"); This. sqladdress ="- H"+ IP +"- u"+ User +"- P"+ Password +"newdb";//Backup of the databasePrivate voidBtn_dump_click (Objectsender, EventArgs e) { using(SaveFileDialog SFD =NewSaveFileDialog ()) {sfd. Filter="database File |*.sql"; SfD. FilterIndex=0; SfD. Restoredirectory=true; SfD. FileName="BackUp"+ DateTime.Now.ToString ("YYYYMMDDHHMMSS") +". SQL"; if(SFD. ShowDialog () = =System.Windows.Forms.DialogResult.OK) {stringFilePath =SFD. FileName; stringcmd ="mysqldump"+ sqladdress +"> \ ""+ FilePath +"\""; stringresult =runcmd (CMD); if(result.) Trim () = ="") {MessageBox.Show ("database backup succeeded!","CMS", MessageBoxButtons.OK, messageboxicon.information); } Else{MessageBox.Show (result,"CMS", MessageBoxButtons.OK, messageboxicon.information); } } }}//Restoring a database//Restoring a databasePrivate voidBtn_import_click (Objectsender, EventArgs e) { if( This. Tb_Path.Text.Trim () = ="") {MessageBox.Show ("Please select the file you want to recover!","CMS", MessageBoxButtons.OK, messageboxicon.information); return; } //This . Getexecute (G_con, "CREATE database if not exists clothes"); stringFilePath = This. Tb_Path.Text.Trim (); stringcmd ="MySQL"+ sqladdress +"< \ ""+ FilePath +"\""; stringresult =runcmd (CMD); if(result.) Trim () = ="") {MessageBox.Show ("database recovery is successful!","CMS", MessageBoxButtons.OK, messageboxicon.information); } Else{MessageBox.Show (result,"CMS", MessageBoxButtons.OK, messageboxicon.information); }}//command-line OperationsPrivate stringRuncmd (stringcommand) { //Example ProcessProcess p =NewProcess (); p.StartInfo.FileName="Cmd.exe";//determine the program nameP.startinfo.arguments ="/ C"+ command;//determine the program command lineP.startinfo.useshellexecute =false;//use of the shellP.startinfo.redirectstandardinput =true;//REDIRECT inputP.startinfo.redirectstandardoutput =true;//REDIRECT outputP.startinfo.redirectstandarderror =true;//REDIRECT output errorP.startinfo.createnowindow =true;//Setting the display windowP.start ();//xxp.standardinput.writeline (command); //You can also enter the command in the line in this wayP.standardinput.writeline ("Exit");//add exit or the next line of code//p.WaitForExit (); //P.close (); //return P.standardoutput.readtoend (); //output out stream get command line result Fruit returnp.standarderror.readtoend ();}
Backup and restore initialization of MySQL database in C #