restoring database using c#

altafmohd

sir i providing code by which i am implementing restore database ....but sir code is running successfully but no restoration is done at the end ...... help plz thanx in advance :)

public void Restore()
{
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\\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;


            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!");
        }
    }

    private void bstart\_Click(object sender, EventArgs e)
    {
        Restore();
    }

Ravi Bhavnani

You'll need to provide more information - what does the mysqlimport.exe process output? /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

altafmohd

sir what do you mean by the output of mysqlimport.exe i did not get it .......could you please tell in detail thank you :)

Ravi Bhavnani

I meant the result displayed by running mysqlimport.exe. That would indicate what caused the import to fail. /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

altafmohd

no result and no exception .....and code is running till the end ......

Ravi Bhavnani

What's the value of Process.ExitCode[^] ? /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

altafmohd

sir its 1

Ravi Bhavnani

That indicates the process terminated with an error. The fastest way (IMHO) to determine what caused the problem is to:

Debug your app and see what arguments you're passing the .exe
Run the .exe manually (in a command window) using those arguments and inspect the output

/ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

Lost User

You, sir, should be nominated for sainthood or something. Nicely done.

Why is common sense not common? Never argue with an idiot. They will drag you down to their level where they are an expert. Sometimes it takes a lot of work to be lazy Individuality is fine, as long as we do it together - F. Burns

Ravi Bhavnani

Thanks, Wes! Just trying to live up to the CPian code - bad puns intended. :) /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

altafmohd

sir please tell me is this line which i am passing in filename of psi is correct or not? psi.FileName = @"C:\Program Files\MySQL\MySQL Server 5.0\bin\mysqlimport.exe";

Ravi Bhavnani

Assuming that's where MySql is installed, probably yes. Did you try running the command manually? /ravi

My new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com

altafmohd

yes sir that is stored there ....ok i will run actualy there is problem in system as soon as it will be functioning well

Vipin_Arora

Hi altaf bhai, if u want to restore the DB from .bak file then try folllowing link:http://stackoverflow.com/questions/9403299/backup-and-restore-sql-database[^] It may be very useful for u

altafmohd

sir but in this link the database is sql server and i am using mysql database ....:(