.net mysql 备份,如何使用c＃.net备份和恢复MySQL数据库

Hi........

I am doing a windows application in that i used MySQL as back end.I want to take the backup of Database by writing code in c#.net. If any body knows please send me that code. I googled but no use. I found one code but but its coming for 1st table only. I wan the whole Database.

This is the code which i used...try

{

DateTime backupTime = DateTime.Now;

int year = backupTime.Year;

int month = backupTime.Month;

int day = backupTime.Day;

int hour = backupTime.Hour;

int minute = backupTime.Minute;

int second = backupTime.Second;

int ms = backupTime.Millisecond;

String tmestr = backupTime.ToString();

tmestr = "D:\\" + year + "-" + month + "-" + day + "-" + hour + "-" + minute + ".sql";

StreamWriter file = new StreamWriter(tmestr);

ProcessStartInfo proc = new ProcessStartInfo();

string cmd = string.Format(@"-u{0} -p{1} -h{2} {3} ", "root", "sa", "localhost", "employee", "backup.sql");

proc.FileName = @"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqldump";

proc.RedirectStandardInput = false;

proc.RedirectStandardOutput = true;

proc.Arguments = cmd;//"-u root -p smartdb > testdb.sql";

proc.UseShellExecute = false;

Process p = Process.Start(proc);

string res;

res = p.StandardOutput.ReadToEnd();

file.WriteLine(res);

p.WaitForExit();

file.Close();

MessageBox.Show("Backup Done");

}

catch (IOException ex)

{

MessageBox.Show("Disk full or other IO error , unable to backup!");

}

But its coming for the 1st table only...

I want the whole database.

Thanks in advance......

解决方案I can only assume that you didn''t google very hard, or used a poor search phrase.

I just tried, using c# mysql backup and the first few hits that I looked at had code samples.