the ampersand sign "&" will make backgrounding for the process .and i think mysql is a shell-like that should be presented to type your commands(queries or what ever).

I did not get the question .but if he means that he want to supply the user name , password and the source path. here is the script

#!/bin/bash
echo "Enter user name"
read user
echo "Enter password"
read passwd
echo "Enter source path"
read srcpath
mysql -u $user -p $passwd source=$srcpath
#i do not think the source thing will work fine

this will take the username and it's pasword and the source path(i do not know what is the source path here but as he supplied on his post.

if he means to apply some create statement or some what ever.

mysql - user -p passwd < myfile.mysql

but this is not script at all.

Diaa Radwan

You don't need that

mysql installation is generally done redirecting a mysql dump

ie: mysqladmin -d database -u user -p pwd < mysql_dump.sql

so an installation script would just call that command with the dump you provided along with the package

I used to be indecisive .. but now I'm not so sure

you put your sql code in a file then run

$ mysql -u username -p databasename < foo.sql

note that you end the command with the database name, this will prompt for the password, if you want to put the password on the command line the syntax is

$ mysql -u username -ppassword databasename < foo.sql

incidentally if you want to do the opposit and dump an turn an existing database into an sql script use

$ mysqldump -u username -p databasename > foo.sql

cheers, Alaa

http://www.manalaa.net "i`m feeling for the 2nd time like alice in wonderland reading el wafd"

reading your question it seems you're deploying an app or something that needs to add stuff to mysql. the way to do it is to provide a dump of the tables and the like and use mysqladmin to load it. the manual will tell you more about the syntax

look into any of the app that uses a db as backend for inspiration. they use that method. depending on the level of automation the user is required to run the mysqladmin manually or the script asks him for db root pwd

since you need root pwd to create a new db and grant permissions on it. once you've set it up you can proceed creating a new user for the app and use that

this is the best/secure/widespread approach

I used to be indecisive .. but now I'm not so sure

bemonasbet el kalam 3an MySql wel SQL scripts. how can i extract the sql script (schema) for creating a database from an exsiting MySQL database. i mean some thing like this one in the SQLServer Enterprise manager which i can generate the sql script that generates the database back on other servers.

Thank you.

read my comment above

cheers, Alaa

http://www.manalaa.net "i`m feeling for the 2nd time like alice in wonderland reading el wafd"