[at] Burkhard Ott : Thanks, but there Im just trying to write an file
with extention .sql so it cant be a issue of MySQL rights.
[at] Cyrus Kriticos : Thanks, I took the decision to go other way, instead
of writing the sql file where I was putting commands to create
database and grant privileges and then running it in shell script. Now
Iam not creating that file instead I do this
mysqladmin -usuper -pduper create $profile [this creates database for
profile]
mysql -usuper -pduper -e "grant all on $profile.* to root [at] localhost
identified by 'duper'" [this grants privileges]
Thanks again,
Saurabh
On Jan 2, 7:20 pm, Cyrus Kriticos <cyrus.kriti... [at] googlemail.com>
wrote:
> Saurabh wrote:
>
> > Background:
> > =======
> > I am running a shell script from my perl script (web page). Shell
> > script creates a file database.sql which then I use to create database
> > and table structure.
>
> > Code
> > ====
> > Perl
> > -----
> > my [at] output = system("install_my_profile.sh <parameters>");
>
> To debug add to your script:
>
> > Shell Script [install_my_profile.sh]
> > --------------
>
> pwd
> echo "$mysql"
> set -x> echo -e $mysql>database.sql
>
> set +x
>
> > this gives error permission denied, I have changed directory ownership
> > to apache:apache
>
> --
> Best regards | Be nice to America or they'll bring democracy to
> Cyrus | your country.
