exception while taking mysql database back up

Question

0.00/5 (No votes)

See more:

Hi all
I used this code for taking mysql back up

try
        {
            DateTime Time = DateTime.Now;
            int year = Time.Year;
            int month = Time.Month;
            int day = Time.Day;
            int hour = Time.Hour;
            int minute = Time.Minute;
            int second = Time.Second;
            int millisecond = Time.Millisecond;

            //Save file to C:\ with the current date as a filename
            string path;
            path = "D:\\MySqlBackup" + year + "-" + month + "-" + day +"-" + hour + "-" + minute + "-" + second + "-" + millisecond + ".sql";
            StreamWriter file = new StreamWriter(path);


            ProcessStartInfo psi = new ProcessStartInfo();
            psi.FileName = "mysqldump";
            psi.RedirectStandardInput = false;
            psi.RedirectStandardOutput = true;
            psi.Arguments = string.Format(@"-u{0} -p{1} -h{2} {3}",
                "root1", "root", "localhost", "schoolmanagement");
            psi.UseShellExecute = false;

            Process process = Process.Start(psi);

            string output;
            output = process.StandardOutput.ReadToEnd();
            file.WriteLine(output);
            process.WaitForExit();
            file.Close();
            process.Close();
}

now here i got exception as

System.ComponentModel.Win32Exception: The system cannot find the file specified at this line(Process process = Process.Start(psi);)

how do i resolve my problem can any one help me please
thanks in advance

Posted 12-Apr-11 0:24am

tulasiram3975

Updated 12-Apr-11 0:31am

m@dhu

v2

Add a Solution

Comments

m@dhu 12-Apr-11 6:31am

wrapped the code.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

OriginalGriff · Accepted Answer · 2011-04-12T00:43:00

Solution 1

Two potential problems / causes:
1) You may have permissions problems writing to the root of a disk under Vista/Win7. it is good idea not to rely on storing info there.
2) The system cannot find "mysqldump" as an executable. Make sure it is installed correctly, or specify the full path to the program

Posted 12-Apr-11 0:43am

OriginalGriff

Comments

tulasiram3975 12-Apr-11 7:14am

Thanks For The Replay,
Sir What I Need to Do Now(itr was installed correctly some times working but not taking
back up it returns 1kb .sql file.

Member 7945810 24-May-11 3:44am

Thank You very much.Now its working.....

Wendelius · Accepted Answer · 2011-04-12T09:12:00

Instead of fetching the data from output and writing to a file, try directing the backup directly to disk (note 4 backslashes):

C#

...
path = "D:\\\\MySqlBackup" + year ...
...
psi.Arguments = string.Format(@"-u{0} -p{1} -h{2} {3} > {4}",
                "root1", "root", "localhost", "schoolmanagement", path)
...

The output may be extremely large (depending on the database size) so you shouldn't route it through the program unless yo need to interpret it.

Also catch the StandardOutput[^] and StandardError[^] from the process to see if something goes wrong.