MySQL restore database through c# - C# Discussion Boards

Re: How to Upload large size file to server

musefan30-Jun-09 2:43

musefan

30-Jun-09 2:43

I see

Just out of interested what is your project? is it a course project?

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

Vimalsoft(Pty) Ltd30-Jun-09 2:47

Vimalsoft(Pty) Ltd

30-Jun-09 2:47

My Company is in Education Industry

My Department Smile | :)

Timetabling
==============

We Create Clash Free Timetables

Where i come in
===============

ASP.NET 2.0, 3.5

Silverlight 2

WPF

SQL

Cool Suspicious | :suss:

We are release a new Version of our Product , so worked every Sunday Smile | :)

but that has come to an end today Smile | :)

Vuyiswa Maseko,

Few companies that installed computers to reduce the employment of clerks have realized their expectations.... They now need more and more expensive clerks even though they call them "Developers" or "Programmers."

C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.somee.com
http://www.vuyiswamaseko.tiyaneProperties.co.za
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/

Re: How to Upload large size file to server

musefan30-Jun-09 2:58

musefan

30-Jun-09 2:58

Interesting Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

musefan30-Jun-09 2:33

musefan

30-Jun-09 2:33

I have not really read your code but my first guess would be your buffer array size is causing the issue. The buffer should not contain all the data else you may as well use the stream itself.

Try a buffer size of 1024 - that's a common size that is used.

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

wasimsharp30-Jun-09 2:42

wasimsharp

30-Jun-09 2:42

yes i set the buffer size to 1024
it working but in process it threw exception couple of time "The underlying connection was closed: An unexpected error occurred on a receive."

WANTED wasim khan(Killed 50 Innocent Buggs, Distroyed 200 Exception, make 5 Project Hostage) any Compnay Hire him will pay 30,000. Best place where u can get him is Sorcim Technologies Murre Road RWP

Re: How to Upload large size file to server

musefan30-Jun-09 3:01

musefan

30-Jun-09 3:01

Try creating the response stream (and closing it) outside of the while loop then just write the buffer contents in each loop.

Life goes very fast. Tomorrow, today is already yesterday.

Re: How to Upload large size file to server

Anthony Mushrow30-Jun-09 3:08

Anthony Mushrow

30-Jun-09 3:08

Two things.

i = stream.Read(buffer,0, buffer.Length)

That's fine, but later on

reqStream.Write(buffer, 0, buffer.Length);

You try to send the whole buffer, but if you only read 215 bytes in to the buffer in the first place then you would be sending garbage.

You should use the variable you set before to make sure you only send what you read in.

reqStream.Write(buffer, 0, i);

It would probably be fine since the whole file would be put in the buffer, but just to be safe.

As for your other problem, if you use BeginWrite you need to wait until the callback before closing the stream, at the moment you could be closing the stream while you're still trying to send data down it.

If you where to use the regular Write method, you would probably want to check how many bytes where actually written and make sure you send all of your data.

My current favourite word is: Delicious!

-SK Genius

Game Programming articles start -here[^]-

MySQL restore database through c#

mariamkhaqan30-Jun-09 2:06

mariamkhaqan

30-Jun-09 2:06

Hi I have used multiple ways to restore mysql schema through c# but it doesnot seems to work as the database doesnot restores properly,
please tell me what to do, my code for restore is as under

string filename = backupName;
                StreamWriter file = new StreamWriter(filename);
                file.WriteLine("@ECHO off");
                file.WriteLine("cls");
                file.WriteLine("set DBchoice=%1%");
                file.WriteLine("set User=%2%");
                file.WriteLine("set Password=%3%");
                file.WriteLine("set pathchoice=%4%");
                file.WriteLine("");
                file.WriteLine("@REM Remove double quotes from the path");
                file.WriteLine("@REM SET pathchoice=%pathchoice:\"=%");
                file.WriteLine("@REM SET pathchoice=%pathchoice:\"=%");
                file.WriteLine("");
                file.WriteLine("mysql -u " + Id + " --password=" + pwd + " " + dbName + "<" + path);

                file.Close();

the other one is

StreamReader file = new StreamReader(path);
                ProcessStartInfo proc = new ProcessStartInfo();
                string cmd = string.Format(@"-u{0} -p{1} -h{2} {3} {4} {5}", Id, pwd, serverHost, dbName + "<", path);
                proc.FileName = "mysql";
                proc.RedirectStandardInput = true;
                proc.RedirectStandardOutput = false;
                proc.Arguments = cmd;//"-u root -p smartdb > testdb.sql";
                proc.UseShellExecute = false;
                Process p = Process.Start(proc);
                string res;

                res = file.ReadToEnd();
                p.StandardInput.Write(res);

                // res = p.StandardInput.Write .StandardOutput.ReadToEnd();
                //file.WriteLine(res);
                p.WaitForExit();
                file.Close();
                return "Data restored successfully";

please give me any suggestions

regards,
Mariam

Re: MySQL restore database through c#

Pavel123123__27-Oct-09 5:32

Pavel123123__

27-Oct-09 5:32

StreamReader file = new StreamReader(fromFile);
string res;
res = file.ReadToEnd();
file.Close();
ProcessStartInfo proc = new ProcessStartInfo();
proc.FileName = "mysql.exe";
proc.CreateNoWindow = true;
proc.RedirectStandardInput = true;
proc.Arguments = string.Format(" -u{0} -p{1} -h{2} -D{3}", userName, password, serverName, databaseName);
proc.UseShellExecute = false;
p.StandardInput.Write(res);
p.StandardInput.WriteLine("quit");

Re: MySQL restore database through c#

adiono26-Dec-09 23:52

adiono

26-Dec-09 23:52

I've try this code and it's work fine!

StreamReader file = new StreamReader(restoreFile);
ProcessStartInfo proc = new ProcessStartInfo();
string cmdArgs = string.Format(@"-u{0} -p{1} -h{2} {3}", UserID, Password, Location, DatabaseName);
proc.FileName = "C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysql.exe";
proc.RedirectStandardInput = true;
proc.RedirectStandardOutput = false;
proc.Arguments = cmdArgs;
proc.UseShellExecute = false;
Process p = Process.Start(proc);
string res = file.ReadToEnd();
file.Close();
p.StandardInput.WriteLine(res);
p.Close();

"&lt;" or "<" can causes error because ProcessStartInfo doesn't recognize it!
Good Luck!

Re: MySQL restore database through c#

ogimenezb31-May-11 6:05

ogimenezb

31-May-11 6:05

I have been looking around because I have big dumps (200MB) and .NET kept going out of memory.

The solution is:

ProcessStartInfo proc = new ProcessStartInfo();
string cmdArgs = string.Format(@"-u{0} -p{1} -h{2} {3}", UserID, Password, Location, DatabaseName);
proc.FileName = "C:\\Program Files\\MySQL\\MySQL Server 5.1\\bin\\mysql.exe";
proc.RedirectStandardInput = true;
proc.RedirectStandardOutput = false;
proc.Arguments = cmdArgs;
proc.UseShellExecute = false;
Process p = Process.Start(proc);
p.StandardInput.WriteLine("source " + restoreFile);
p.Close();

Sql query designer

Dushan12330-Jun-09 1:28

Dushan123

30-Jun-09 1:28

I need to develope simple sql query designer. basicaly i have problem on represent the joins. please help me to do this task.

Dushan Perera

Re: Sql query designer

J4amieC30-Jun-09 1:32

J4amieC

30-Jun-09 1:32

Dushan123 wrote:
please help me to do this task.

Any specific help you want, or should we engage our mindreading skills?

Re: Sql query designer

musefan30-Jun-09 2:16

musefan

30-Jun-09 2:16

J4amieC wrote:
or should we engage our mindreading skills?

No, save that for the forums dedicated to mindreaders

Life goes very fast. Tomorrow, today is already yesterday.

Re: Sql query designer

J4amieC30-Jun-09 2:17

J4amieC

30-Jun-09 2:17

Most of the time, this is that forum Hmmm | :|

Re: Sql query designer

musefan30-Jun-09 2:19

musefan

30-Jun-09 2:19

J4amieC wrote:
Most of the time, this is that forum

you did not have to write that, I already knew you were going to say it Wink | ;)

Life goes very fast. Tomorrow, today is already yesterday.

Re: Sql query designer

musefan30-Jun-09 2:30

musefan

30-Jun-09 2:30

....hmmmm, that's an interesting thought...

Life goes very fast. Tomorrow, today is already yesterday.

Re: Sql query designer

K030630-Jun-09 2:06

K0306

30-Jun-09 2:06

I think you are asking about Joins in SQL, if this right,try the below links for Joins

SQL Join Link1[^]

SQl Joins Link2[^]

Re: Sql query designer

Dushan12330-Jun-09 2:31

Dushan123

30-Jun-09 2:31

I need to visualize the sql joins like sql query analyzer

Dushan Perera

Re: Sql query designer

musefan30-Jun-09 2:18

musefan

30-Jun-09 2:18

Dushan123 wrote:
I need to develope simple sql query designer

the word 'simple' strikes me as being one you clearly should not have included in a post asking for help.

I mean, if it's so simple then why do you need help with it

Life goes very fast. Tomorrow, today is already yesterday.

Re: Sql query designer

Pete O'Hanlon30-Jun-09 2:36

Pete O'Hanlon

30-Jun-09 2:36

OK - what have you got so far? How are you representing your tables? What diagramming methods are you using?

"WPF has many lovers. It's a veritable porn star!" - Josh Smith

As Braveheart once said, "You can take our freedom but you'll never take our Hobnobs!" - Martin Hughes.

My blog | My articles | MoXAML PowerToys | Onyx

show custom control in aspx page

Pankaj Saha30-Jun-09 1:27

Pankaj Saha

30-Jun-09 1:27

Hi, I have a web application with a single page, where I put a textbox in that form. Then I build the project. Now I have another web application and want the previous web application page in this application. I mean I want to show the previous application's page into my current application's page as a user control. Confused | :confused:

Pankaj

Re: show custom control in aspx page

Vimalsoft(Pty) Ltd30-Jun-09 1:37

Vimalsoft(Pty) Ltd

30-Jun-09 1:37

Create a userControl and add what ever controls you want, and from your Solution Explorer Drag it and Drop it in your host page , it will be registered and you can use it. Smile | :)

Simple

Re: show custom control in aspx page

Pankaj Saha30-Jun-09 1:53

Pankaj Saha

30-Jun-09 1:53

Thanks for your replay. But this is not my problem. I have a web application not class library. And I have to show this web application form to my new web application as a control.

Pankaj

Connect C# win app and ASP.Net/C# website using HttpRequests?

Mtyb30-Jun-09 1:19

Mtyb

30-Jun-09 1:19

Hello,

Win App:
takes a value from a textbox1 and send it throw parameter to a method in the website called WebDisplay(textbox1.text)

Web App:
WebDisplay method recives the parameter.

so how can i do that..?

thanks!

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.