urgent help needed

[roottybrian]

Am trying to restore a MySQL database using the 'mysql -u root db < my_db' command. In vb's process.start. it gives me the default output you get when you type MySQL - help. Can someone tell me what's up. I guess it cannot see the < symbol. Regards.

[thines01]

Are you passing the arguments correctly?
http://msdn.microsoft.com/en-us/library/h6ak8zt5.aspx#Y1690

[roottybrian]

Are you passing the arguments correctly?
http://msdn.microsoft.com/en-us/library/h6ak8zt5.aspx#Y1690

Infact arguments without the < symbol work perfectly well but every time I use the <symbol for MySQL restore db, it fails.

[thines01]

I understand.
That's a "shell" issue and from what I remember, more complicated.
Can you then write the commands into a batch file, then process-start the batch file? :(

[Begginnerdev]

You could also write a tiny app with a text box. The user puts the sql command in the text box and presses a button. The button will fire off code that will bind the text string to a command and ExecuteNonQuery.

[roottybrian]

I understand.
That's a "shell" issue and from what I remember, more complicated.
Can you then write the commands into a batch file, then process-start the batch file? :(

Thanks. Using a batch file works perfectly. Kudos guys.