how to call and execute MySQL commands programmatically?

Question

I want to run all commands programmatically and the commands are like:

string mysql ="C:\Program Files\MySQL\MySQL Server 5.1\bin"
string command =" mysql.exe -u root -ppassword fabrica < c:/backup.sql";

I want to run these two lines using C#, how can I achieve this?

Process.Start("cmd", "/c "+"\"C:\Program Files\MySQL\MySQL Server 5.1\bin\mysql.exe\""+" -u root -ppassword fabrica < c:/backup.sql") — Tilak
– Tilak, Commented Dec 6, 2012 at 17:14
May I suggest, CLI may not be the most productive way to interact with your database. — Jodrell
– Jodrell, Commented Dec 6, 2012 at 17:20

Obama · Accepted Answer · 2012-12-06 18:16:06Z

3

EDITED : Now i know what you want to do exactly

Here is a code to make it in a method

string binary = @"C:\MySQL\MySQL Server 5.0\bin\mysqldump.exe"
string arguments = @"-uroot -ppassword sample"
ProcessStartInfo PSI = new System.Diagnostics.ProcessStartInfo(binary, arguments);
PSI.RedirectStandardInput = true;
PSI.RedirectStandardOutput = true;
PSI.RedirectStandardError = true;
PSI.UseShellExecute = false;
Process p = System.Diagnostics.Process.Start(PSI);
Encoding encoding = p.StandardOutput.CurrentEncoding;
System.IO.StreamWriter SW = new StreamWriter(@"c:\backup.sql", false, encoding);
p.WaitOnExit();
string output = p.StandardOutput.ReadToEnd()
SW.Write(output)
SW.Close();

Good luck!

edited Dec 6, 2012 at 18:16

answered Dec 6, 2012 at 17:16

Obama

2,6322 gold badges33 silver badges49 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Saqi Over a year ago

this line not executing pr.StartInfo.Arguments = @"mysql.exe -u root -ppassword fabrica < c:/backup.sql";

Saqi Over a year ago

no any exception . after executing this command prompt stop on "C:\Program Files\MySQL\MySQL Server 5.1\bin"; next line not executing

Obama Over a year ago

do you want to dump a MySQL database? using c#

Saqi Over a year ago

and dump backup i think we cant restore using Msql application

Collectives™ on Stack Overflow

how to call and execute MySQL commands programmatically?

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related