restore

[nitish_07]

BasePriority = 'process.BasePriority' threw an exception of type 'System.InvalidOperationException'...This is the exception I am getting while restoring the database from my .net application..Here I am providing the code....

try
{
//Read file from C:\
string path;
path = filetext.Text;
StreamReader file = new StreamReader(path);
string input = file.ReadToEnd();
file.Close();

            ProcessStartInfo psi = new ProcessStartInfo();
            psi.FileName = @"C:\\Program Files (x86)\\MySQL\\MySQL Server 5.0\\bin\\mysqlimport.exe";
            psi.RedirectStandardInput = true;
            psi.RedirectStandardOutput = false;
            psi.Arguments = string.Format(@"-u{0} -p{1} -h{2} {3}",
               userid, paswd, server, comboBox1.Text);
            psi.UseShellExecute = false;

            Console.WriteLine(psi);
            Process process = Process.Start(psi);
            process.StandardInput.WriteLine(input);
            process.StandardInput.Close();
            process.WaitForExit();
            process.Close();
            MessageBox.Show("database is restored");
        }
        catch (IOException ex)
        {
            MessageBox.Show("Error , unable to Restore!");
        }

Plz provide any suggestion....

[Abhinav S]

You cannot set the BasePriorty as this is a read only Property. The return type of this property is an integer. Read more about this here[^] . You have not provided the code for this statement, so its hard to figure out what you were trying to do.

[ProEnggSoft]

To the point. +5

[PIEBALDconsult]

Yeah, I don't see such a statement, but maybe you need something like this:

    try
    {
      process.PriorityClass = System.Diagnostics.ProcessPriorityClass.BelowNormal ;
    }
    catch
    {
      /\* The process probably already exited due to error \*/
    }

[altafmohd]

yes sir process is already exiting due to error .........i am also unable to understand why the process is exiting ...give some solution thanks

[PIEBALDconsult]

You'll need to check the output. You may need to redirect and capture the output.

[altafmohd]

how i can do this ....provide what code i should use or steps to do that thanks in advance :):):)

[nitish_07]

As pointer reach to line Process process=process.start(psi), command line windows opens for a second and then closes and when after this line I watch the output it throws that exception that process has existed....