MySQL database backup from the client

[Fraser Campbell]

Madison Kelly wrote:

>   I have been all over the MySQL (4.1) docs trying to find a way to dump 
> a database from within MySQL (through perl). I know I can make a sysem 
> call to 'mysqldump' but then I would have to pass the password 
> essentially over the commnd line which expses it (even if for just a 
> moment).

You don't have to put your password on the command line.  You can put 
passwords into your config file.  Create a ~/.my.cnf file for whichever 
user is running the dump and in there put something like:

   [mysqldump]
   password=xyz

Or maybe it's like this (haven't used it in a while):

   [client]
   password=xyz

--
The Toronto Linux Users Group.      Meetings: http://tlug.ss.org
TLUG requests: Linux topics, No HTML, wrap text below 80 columns
How to UNSUBSCRIBE: http://tlug.ss.org/subscribe.shtml