MySQL database backup from the client

[Madison Kelly]

Hi,

   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).

   I know you can use 'SHOW CREATE TABLE xyz' to get the table schema 
then 'BACKUP TABLE...' or 'SELECT INTO ... OUTFILE' to get the data but 
this would e, to say the least, combersome. Is there something like 
'BACKUP DATABASE foo OUTFILE ...'?

   There is no concern in my case about the database being accessed 
while I do the dump.

Thanks!

Madison

-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
           Madison Kelly (Digimer)
    TLE-BU; The Linux Experience, Back Up
Main Project Page:  http://tle-bu.org
Community Forum:    http://forum.tle-bu.org
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-
--
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