restoring database using c#
-
sir what do you mean by the output of mysqlimport.exe i did not get it .......could you please tell in detail thank you :)
I meant the result displayed by running
mysqlimport.exe
. That would indicate what caused the import to fail. /raviMy new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com
-
I meant the result displayed by running
mysqlimport.exe
. That would indicate what caused the import to fail. /raviMy new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com
-
What's the value of
Process.ExitCode
[^] ? /raviMy new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com
-
What's the value of
Process.ExitCode
[^] ? /raviMy new year resolution: 2048 x 1536 Home | Articles | My .NET bits | Freeware ravib(at)ravib(dot)com
-
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
- Debug your app and see what arguments you're passing the
-
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
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
- Debug your app and see what arguments you're passing the
-
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
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
-
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
-
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";
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
-
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
-
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(); }
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
-
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