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.

Recommended Answers

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? :(

Jump to Post

All 5 Replies

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? :(

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.

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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.