script/command for taking automatic backup of mysql database

[bruce]

ankush,

i wasn't aware that mysql 'allowed' you to access the mysql db/table using
an 'encrypted' passwd. furthermore, i'm not sure that this would get you
where you want to go anyway. you seem to want to set up a process to allow
the db/table to be backed up. to do this, mysql requires the use of the
username/passwd. you hope to provide an encrypted passwd, to allow your
process to work. but if mysql allowed this, then wouldn't someone be able to
still access your mysql db/table in the same manner????

so, either way, you need to provide a 'passwd' in a manner that someone with
the appropriate access privs will unfortunately still be able to see. you're
not the 1st to want to accomplish this, so i would imagine that there are
various methods to accomplish this.

check the mysql website, or post this question to the mysql email list if
you haven't already. i'm pretty sure you'll get your answer fairly quickly!

-bruce



-----Original Message-----
From: fedora-list-bounces at redhat.com
[mailto:fedora-list-bounces at redhat.com]On Behalf Of Ankush Grover
Sent: Tuesday, August 02, 2005 5:08 AM
To: gb spam; For users of Fedora Core releases
Subject: Re: script/command for taking automatic backup of mysql
database


> > password where as the password is given in the command in my case the
> > password for root user is  *F298CEE6BE03DAEB0D515166F40879C6DD1D24F3"
> > .
> >
>
> remove the space between "-p" and the password.  ie, use
>
>    -p*F298CEE6BE03DAEB0D515166F40879C6DD1D24F3
>


I did remove the space but still it is not working.
The "*F298CEE6BE03DAEB0D515166F40879C6DD1D24F3" is encrypted password
and may be mysqldump does not recognizes the encrypted password.The
encrypted password is created through "select password(' ankush') " at
the mysql prompt.

Do you know the minimum requirements for a user to issue mysqldump
command.Means what privlieges it requires like select,lock tables etc.

Thanks & Regards

Ankush Grover

--
fedora-list mailing list
fedora-list at redhat.com
To unsubscribe: http://www.redhat.com/mailman/listinfo/fedora-list