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.
roottybrian 0 Junior Poster in Training
thines01 401 Postaholic Team Colleague Featured Poster
roottybrian 0 Junior Poster in Training
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 401 Postaholic Team Colleague Featured Poster
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 256 Junior Poster
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 0 Junior Poster in Training
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 developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.