how to run sql query

[Mandargholap]

Hi,

I have a simple .sql file which will create a database in mySQL.
pl. help me to run this .sql file from vb6 program with shell command.

Also tell me, how to add a username and password in the Shell command.

[Atli]

Hi.

You should be able to execute a shell command like so:

mysql -u userName -p < /path/to/file.sql

Which should execute the SQL commands in that .sql file as that user.

This would prompt you for a password tho. Not sure how you would handle that in VB.

[Marjeta]

Here's how I run it:
mysql --host=<hostname> --socket=<socket> -u <user> -p<password> <databasename > < <script>

or, an example
mysql --host=localhost --socket=/var/lib/mysql.sock -u myuser -pmypass mydb < test.sql

Note: there's no space between -p and the password.